Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vertical search and NULL
Hi Gents,
I am doing a vertical search to return some data from a selected area. Everything works fine unless the value I am looking for is not present and therefore the formula returns #N/D, which ruins everything else I intend to program. What can I do to NOT see a NULL value (#N/D) but something else instead? I could use the IF formulas, but it does not work with "#N/D". Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching for first and last in a table to chart (gantt) | Excel Discussion (Misc queries) | |||
Replace null string with blank cell | Excel Discussion (Misc queries) | |||
Lookup with search range start based on position of last blank lin | Excel Worksheet Functions |