Picture this. Blank worksheet. In cell A1 I have the text "Chicken". In column D i have a large list of foods (Fruit, Eggs, Veggies, Salad, Chicken ect.).
My question is: what fuction can I place in cell B1 that tells me if A1 "chicken" is in the list/array/range found in column D?
I has to return either the text "chicken" or True/False. Thank you very much.
2007-10-06 07:07:57 · 4 answers · asked by Michael F 1 in Computers & Internet ➔ Software
=(VLOOKUP(A1,D1:D20,1,FALSE))
Just be sure your range in column D is the range of the list in column D that you need to look at. I just used D1 through D20 as example.
2007-10-06 07:30:07 · answer #1 · answered by got2bami 2 · 4⤊ 0⤋
I'd either recommend using the VLOOKUP function like got2bami mentioned. Or you might check out the website below to find out about data validation and dependent lists. I think you'll find the info definitely interesting.
http://www.contextures.com/xlDataVal02.html
2007-10-09 11:51:10 · answer #2 · answered by devilishblueyes 7 · 0⤊ 0⤋
You might try the Exact function. Exact is case sensitive
Good Luck
2007-10-06 14:13:19 · answer #3 · answered by Ernie B 7 · 0⤊ 2⤋
You may want to use the "exact" function
2007-10-06 14:17:09 · answer #4 · answered by Adam W 2 · 0⤊ 2⤋