Lookup value in table without returning #N/A

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

 

[Gary Brown]

CountIf should do the same thing

 

[Eric_NY]

Good idea! Thanks.

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

 

[Dave Peterson]

I'd use:

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

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.