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

[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.

[Ron Coderre]

Try this:

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

Is that what you're looking for?

Regards,
Ron

[Niek Otten]

=IF(ISNA(MATCH(B1,A1:A100,0)),FALSE(),TRUE())

--
Kind regards,

Niek Otten

"quimrider" <[email protected]> wrote
in message news:[email protected]...
>
> 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.
>
>
> --
> quimrider
> ------------------------------------------------------------------------
> quimrider's Profile:
> http://www.excelforum.com/member.php...o&userid=29009
> View this thread: http://www.excelforum.com/showthread...hreadid=492149
>

[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.