Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup returning incorrect value | Excel Discussion (Misc queries) | |||
Lookup is not returning the right value. | Excel Worksheet Functions | |||
Excel returning more than one value from a lookup table that match the same value | Excel Discussion (Misc queries) | |||
Lookup returning one more than expected | Excel Worksheet Functions | |||
Returning all values from a lookup - not just the first/last one | Excel Worksheet Functions |