| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find cell value within table
I would like to find if the cell value of A1 exists in table A2:AA450
I have tried with ISNA and Match but Match does not seem to work as I have more than one column and row: Match(A1,A2:AA450,0) returns #N/A Any idea? thanks -- caroline |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find cell value within table
Maybe =countif() would work:
=if(countif(a2:aa450,a1)0,"it's there","nope") caroline wrote: I would like to find if the cell value of A1 exists in table A2:AA450 I have tried with ISNA and Match but Match does not seem to work as I have more than one column and row: Match(A1,A2:AA450,0) returns #N/A Any idea? thanks -- caroline -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find cell value within table
yes good idea. Did not think about that one!!!
Thanks -- caroline "Dave Peterson" wrote: Maybe =countif() would work: =if(countif(a2:aa450,a1)0,"it's there","nope") caroline wrote: I would like to find if the cell value of A1 exists in table A2:AA450 I have tried with ISNA and Match but Match does not seem to work as I have more than one column and row: Match(A1,A2:AA450,0) returns #N/A Any idea? thanks -- caroline -- Dave Peterson . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a value in a table and return the cell or column reference | Excel Discussion (Misc queries) | |||
| Find a value in a table and return the cell reference | Excel Worksheet Functions | |||
| How do I find 1 cell value from a 35 Row 12 Column table? | Excel Discussion (Misc queries) | |||
| Find a value in the table cell | Excel Worksheet Functions | |||
| Find first nonblank cell row # in pivot table using MATCH | Excel Worksheet Functions | |||
Hybrid Mode
