Blanks in VLookUP

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

Phil Hageman

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)
 
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,P28:R33,3))

John
 
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
 
Back
Top