Blanks in VLookUP

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

 

[Ron de Bruin]

Try

=IF(ISNA(VLOOKUP(P16,P28:R33,3)),0,VLOOKUP(P16,P28:R33,3))

 

[John Wilson]

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

 

[Trevor Shuttleworth]

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