I need a MATCH formula that can return "true" or "false"

  • Thread starter Thread starter Pedo00ab
  • Start date Start date
P

Pedo00ab

I am looking for a formula similar to the match function, that can look
up a value in a list and return a true or false, depending on whether
or not the value is present in the list. If anybody knows this it would
be a great help....
 
=IF(ISERROR(VLOOKUP(Value,List,1,FALSE)),FALSE,TRUE)
Click to expand...
...

Works, but does too much. Since the OP mentined MATCH, it's reasonable to assume
the range the OP is searching is already 1D, so

=ISNUMBER(MATCH(Value,List,0))

should suffice. If List spanned multiple columns, replace use

=ISNUMBER(MATCH(Value,INDEX(List,0,1),0))
 
Back
Top