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

  • Thread starter Thread starter quimrider
  • Start date Start date
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.
 
Try this:

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

Is that what you're looking for?

Regards,
Ro
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Drop-down list and error message 1
Finding value using greater than, Vlookup, and nested If 2
Looking for IF with VLOOKUP statement with two conditions. 6
If no value found in vLookup, I need to return a NULL to the Cell 4
Using Macros to remove a name from a list 3
Empty cell warning 3
Checkbox Control - How to display a true or false value in the cellcontaining a checkbox 1

Back
Top