Pull value out of list

  • Thread starter Thread starter Heather
  • Start date Start date
H

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!!!
 
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!!!
 
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
 
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
 
You're very welcome Heather, and thanks for the nice thanks.......

Vaya con Dios,
Chuck, CABGx3
 
Back
Top