| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup returning #N/A
i have the formula,
=IF(F21="","",INDEX(Densities!O:P,MATCH(F21,Densit ies!O:O,0),2)) This returns #N/A if the F21 string can not be found It there anyway to get it to return 0 or empty insstead? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup returning #n/a | Excel Discussion (Misc queries) | |||
| Lookup value in table without returning #N/A | Excel Discussion (Misc queries) | |||
| Lookup returning incorrect value | Excel Discussion (Misc queries) | |||
| Lookup is not returning the right value. | Excel Worksheet Functions | |||
| Lookup returning one more than expected | Excel Worksheet Functions | |||
Threaded Mode
