how to get rid of #N/A when not use on vlookup
 

try
= if(iserror(vlookup(A1,sheet2!a4: h100,3,false )),"" ,vlookup(A1,sheet2!a4:
h100,3,false ))

"Curtis" wrote:

I have a data set up using vlookup everything works great except if I have a
cell thats blank for the roll shows #N/A, if I put the product code in blank
it does what its suppose to do but if left blank it shows #N/A how to get rid
of it? I try
( = vlookup(A1=0,"", A1,sheet2!a4: h100,3,false ) but that doesnt work,
any help on this?