Lookup value in table without returning #N/A
 

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.

Lookup value in table without returning #N/A
 

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



"Eric_NY" wrote:

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.

Lookup value in table without returning #N/A
 

Good idea! Thanks.

"Gary Brown" wrote:

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



"Eric_NY" wrote:

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.

Lookup value in table without returning #N/A
 

I'd use:

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



Eric_NY wrote:

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.

--

Dave Peterson