How to get rid of the #N/A and display nothing instead 2

[coolcarls]

Hi again,
I am using this =VLOOKUP(A3,mydata,4,$A$1) and because there is nothing in the cell it's lookin g for right now, it returns me the "Value not available error" #N/A
Is there an "IF" I can put in the formula to prevent this or another workaround or something!! It just looks messy.
Thanks in advance,
Carl

 

[acron]

Try

=IF(ISNA(VLOOKUP(A3,mydata,4,$A$1),0,VLOOKUP(A3,mydata,4,$A$1))

A.C.

 

[coolcarls]

You make it seem SO easy!