Help with formula

[Xpharry1066]

hi all i have got this far with the formula =IFERROR(VLOOKUP(B8,P8:Q1265,2,FALSE),"ERROR! ")

I would really like to not show the "ERROR!" until there is a number in Cell B8 is there a way to do this?

Hopefully i have explained what i need lol (Trying to learn so please be nice lol)

Thanks for your help

 

[Fluff]

Hi & welcome to MrExcel.
If B8 is blank, or has a number try
=IF(B8="","",IFERROR(VLOOKUP(B8,P8:Q1265,2,FALSE),"ERROR! "))

 

[Xpharry1066]

your a Star worked a treat

 

[Fluff]

You're welcome & thanks for the feedback