Lookup value in table without returning #N/A

  • Thread starter Thread starter Eric_NY
  • Start date Start date
E

Eric_NY

In Excel 2003, I have a simple, one-column table with a list of names in it.
I'd like to check to see whether that a particular name is present in the
table.

The only way that I know how to do this is to use VLOOKUP and check for a
#NA error value. Something like: ISNA(VLOOKUP(A1, C1:10, 1, FALSE)).

This is workable but seems a sort of roundabout way to arrive at the result.
Is there any function which provides a more direct way to check whether a
table contains a particular value?

Thanks.
 
Good idea! Thanks.

Gary Brown said:
CountIf should do the same thing
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
 
I'd use:

=isnumber(match(a1,c1:c10,0))



Eric_NY said:
In Excel 2003, I have a simple, one-column table with a list of names in it.
I'd like to check to see whether that a particular name is present in the
table.

The only way that I know how to do this is to use VLOOKUP and check for a
#NA error value. Something like: ISNA(VLOOKUP(A1, C1:10, 1, FALSE)).

This is workable but seems a sort of roundabout way to arrive at the result.
Is there any function which provides a more direct way to check whether a
table contains a particular value?

Thanks.
 
Back
Top