| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
VLOOKUP returns #N/A
The Data sheet contains a column with numeric values. The lookup table deliberately does not contain all of the values found in the Data sheet. When the formula
=VLOOKUP(I6,Fire,2,FALSE) is applied the result is #N/A when the value in I6 is not found in "Fire" lookup. Is there a way to have the result display as a blank cell instead of #N/A when this condition occurrs. Thanks in anticipation. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup returns a zero? | Excel Discussion (Misc queries) | |||
| VLOOKUP Returns #REF | Excel Worksheet Functions | |||
| VLookup returns #VALUE! | Excel Worksheet Functions | |||
| vlookup returns 0.00 | Links and Linking in Excel | |||
| vlookup returns n/a | Excel Worksheet Functions | |||
Threaded Mode
