IF and Vlookup blank cell

[Levent21]

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

[IML]

you could use
=IF(COUNTIF(Supplies!$A$5:$A$20,Sheet1!A13),VLOOKUP(A13,Supplies!$A$5:$B$20,2,0),"")

which will return a "" if it doesn't not exist.

Good luck

[Levent21]

I tried that and it does give me a blank but when when I enter the correct Id it is still blank.

=IF(A13=" "," ",VLOOKUP(A13,Supplies!$A$5:Supplies!$B$30,2))

I don't understand why that doesn't work. When the Id is entered it displays the description but when it is blank I get the #N/A.

[Levent21]

Ah, it works now
=IF(A13=" "," ",VLOOKUP(A13,Supplies!$A$5:Supplies!$B$30,2))

It was the A13=" "
When it should have been a A13"".

I thought it should be a blank, oh well it works..