Sandy

=IF(B2="","",VLOOKUP(B2,....)

Regards

Trevor


"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