| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blanks in VLookUP
What code could be added to this formula, such that if P16
is blank, the cell holding this formula would also be blank? What I get now is an error (#N/A) when P16 is blank. =VLOOKUP(P16,P28:R33,3) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum Vlookup where there are blanks | Excel Discussion (Misc queries) | |||
| VLOOKUP using FALSE returning blanks and #N/A | Excel Worksheet Functions | |||
| Vlookup blanks = zeros | Excel Discussion (Misc queries) | |||
| Excel 2002 : Why VLOOKUP formula does not show blanks or N/A ? | Excel Discussion (Misc queries) | |||
| blanks instead of "0" in vlookup | Excel Discussion (Misc queries) | |||
Threaded Mode
