Lookup a cell in a list to see if it is in the list

Q

quimrider

is there a way to check if a certain cell value is in a list of values?
I need to return a logical TRUE/FALSE. Ie. TRUE if it is in the list
and FALSE if it is not. I could use a rather large OR function but
would prefer a simpler method. I was trying to use MATCH but I
couldnt figure out how to change the #NA to a FALSE value. Any
suggestions would be appreciated.
 
R

Ron Coderre

Try this:

=ISNUMBER(MATCH(A1,your_list,0))

Is that what you're looking for?

Regards,
Ro
 
Q

quimrider

That's exactly what I was looking for... Why didn't I think of
that...LOL
here's my formula:
=IF(ISNUMBER(MATCH(AB16,$AB$1:$AB$12,0)),0,$AA598)
checks if AB16 is in the list and returns 0 if it's not or AA598 if it
is.
 
Top