| 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 |
| 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 | |||
Threaded Mode
