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