Pull value out of list

[Heather]

Hello,

For example:

FALSE
FALSE
Apple
FALSE
FALSE
FALSE


I need to pull the description apple out of this list.
Everything else in this range will be False except one
(being the apple) which I have no clue which cell that
will be. (The apple can end up in any of these cells).
How do I do I locate the apple out of this range?

Please Help!!!

 

[heather]

I forgot to mention I would need to pull banana, orange,
apple, OR strawberry. There will only be one fruit and
the rest will be false but I'm not sure which fruit it
will be as mentioned above. I need the formula to grab
whichever fruit it is out of this range. How would I do
this?

Thanks!!!

 

[acw]

Heather

Assuming that the data is in the range A1-A6 inclusive,
array enter the following formula.
=INDEX(A1:A6,MAX((A1:A6<>FALSE)*(ROW(A1:A6))))
You will have to modify the range accordingly.


Tony

 

[Aladin Akyurek]

=LOOKUP(REPT("z",40),A1:A10)

 

[Muhammad Jawad Mirza]

Suppose your list is typed in cell A1 to A6.

1- Apply formula in cell C1 as =MATCH("Apple",A1:A6,0)
this will give you the location number of apple in the
list which is 3. Keep this thing in mind that it will
match the first occurance of apple in the list.
2- An other modified approach
Apply this formula in Cell C4
=IF(ISNUMBER(MATCH("Apple",A1:A6,0)),"Present","Not
Present")

Thanks for your query and waiting for the next.

Muhammad Jawad Mirza
Sialkot, Pakistan

 

[Heather]

Thank you sooooooo much Chuck! It worked perfectly!!!

Heather

 

[CLR]

You're very welcome Heather, and thanks for the nice thanks.......

Vaya con Dios,
Chuck, CABGx3