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