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)

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)

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)

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 :)