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

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

--
Kind regards,

Niek Otten

"quimrider" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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
>

Try this:

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

Is that what you're looking for?

Regards,
Ro

--
Ron Coderr
-----------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...fo&userid=2141
View this thread: http://www.excelforum.com/showthread.php?threadid=49214

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.


--
quimrider
------------------------------------------------------------------------
quimrider's Profile: http://www.excelforum.com/member.php...o&userid=29009
View this thread: http://www.excelforum.com/showthread...hreadid=492149