I have column called prodID and when an ProdID is entered a vlookup is done to another sheet and enters the description, etc. When a Prod ID isn't entered the othe columns have the #N/A which should be blank. How can I make these cells blank?
This is what I have
=VLOOKUP(A13,Supplies!$A$5:Supplies!$B$30,2)
I have tried putting an IF statement like this
=IF(A13 = " ", B13 = " ", =VLOOKUP(A13,Supplies!$A$5:Supplies!$B$30,2))
but this doesn't work.
Any help appreciated, thanks
This is what I have
=VLOOKUP(A13,Supplies!$A$5:Supplies!$B$30,2)
I have tried putting an IF statement like this
=IF(A13 = " ", B13 = " ", =VLOOKUP(A13,Supplies!$A$5:Supplies!$B$30,2))
but this doesn't work.
Any help appreciated, thanks