See your other post.

--
Biff
Microsoft Excel MVP


"jane" wrote in message
...
I have a similar situation but get NA when there is not match.... have a
solution?

"Biff" wrote:

Hi!

A1 = lookup value (reference cell)

Try this:

=IF(A1="","",your_vlookup_formula_here))

Biff

"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