Hi Sandy,

Try this format with ranges to suit your sheet.

=IF(ISNA(VLOOKUP(B2,$H$4:$I$18,2,FALSE)),"",VLOOKU P(B2,$H$4:$I$18,2,FALSE))

HTH
Regards,
Howard

"Sandy" wrote in message
...
I am trying to create an excel solution using a vlook up, but in the
formula
cell i would like to cell to be blank if nothing has been entered in the
reference cell

Thanks
Sandy