Hide Formula if cell reference is blank?

[Knockers]

Hi, I have this formula

=IFERROR(VLOOKUP(B5,'Return Stock Data'!A$2:B$500,2,FALSE), "Car Stock")

and would like it to return a blank cell if B5 is empty so as I can apply it to all cells and only have it visible when a lookup value is entered into column B.

Any advice?

Cheers

 

[Caleeco]

You wouldnt be able to return a blank cell in the truest sense (without using VBA). You can however, get it to return an empty string so it APPEARS blank.

Something like this perhaps?

=IF(ISBLANK(B5),"",IFERROR(VLOOKUP(B5,'Return Stock Data'!A$2:B$500,2,FALSE), "Car Stock"))

Caleeco

 

[Knockers]

You wouldnt be able to return a blank cell in the truest sense (without using VBA). You can however, get it to return an empty string so it APPEARS blank.

Something like this perhaps?


Caleeco

Top man Caleeco, worked a treat.

Thank you for your help

 

[Caleeco]

Top man Caleeco, worked a treat.

Thank you for your help

No Problem, thanks for letting me know it worked :D

Caleeco

 

[FDibbins]

you could also shorten that to this...
=IF(B5="","",IFERROR(VLOOKUP(B5,'Return Stock Data'!A$2:B$500,2,FALSE), "Car Stock"))