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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blanks in VLookUP
Perhaps the advantage of the solution posted by Tom and John is that it will
cater for other not found situations rather than just blank ... though the OP did say specifically blanks. Regards Trevor "whisperer" wrote in message ... Relying on the 'fact'that P16 is either blank or contains the lookup criteria, the following code is a simpler and faster version of the other suggestions. Faster in that it does not need to do a Vlookup twice. Mind you if you can measure the speed difference I will be very surprised. =IF(P16="","",VLOOKUP(P16,P28:R33,3)) Best Wishes :) |
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) |