| 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) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Blanks in VLookUP
Try
=IF(ISNA(VLOOKUP(P16,P28:R33,3)),0,VLOOKUP(P16,P28 :R33,3)) -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Phil Hageman" wrote in message ... 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) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Blanks in VLookUP
Phil,
=IF(ISNA(yourlookup),0,yourlookup) an example: =IF(ISNA(VLOOKUP(P16,P28:R33,3)),0,VLOOKUP(P16,P28 :R33,3)) or =IF(ISNA(VLOOKUP(P16,P28:R33,3)),"",VLOOKUP(P16,P2 8:R33,3)) John "Phil Hageman" wrote in message ... 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) |
| Reply |
| 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) | |||
Hybrid Mode
