using a vlookup, can i use isblank to show an empty cell

[Guest]

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

 

[Trevor Shuttleworth]

Sandy

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

Regards

Trevor

 

[L. Howard Kittle]

Hi Sandy,

Try this format with ranges to suit your sheet.

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

HTH
Regards,
Howard

 

[Biff]

Hi!

A1 = lookup value (reference cell)

Try this:

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

Biff

 

[Guest]

Hi Trevor,

Thanks very much for the solution, it worked a treat

Thanks Again
Sandy

 

[Trevor Shuttleworth]

You're welcome. Thanks for the feedback

Hi Trevor,

Thanks very much for the solution, it worked a treat

Thanks Again
Sandy

 

[jane]

I have a similar situation but get NA when there is not match.... have a
solution?

 

[T. Valko]

See your other post.