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

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup - N/A 4
VLOOKUP problem 3
How to get rid of #n/a 1
VLOOKUP returning #N/A result 2
#N/A in vlookup 2
get rid of #N/A in a VLOOKUP 6
VLOOKUP - 0 instead of # N/A 8
If condition not met get #N/A 5

Top