How to get rid of #n/a

G

Guest

Have data spread sheet using vlookup, when I leave A7 cell blank this roll
has #n/a the column A1 to A50 are my lookup, if I use any lookup it works but
if left any cell blank I have tons of #n/a how do you get rid of them or fix
it where it doesnt show when not used. I have try this data = vlookup (
a7=0,"",a7,sheet2! A4:h21,3,false )
this does not help.
 
G

Guest

= vlookup (a7=0,"",a7,sheet2! A4:h21,3,false )

One of these should suffice:
=IF(A7=0,"",VLOOKUP(A7,Sheet2!A4:H21,3,FALSE))
o
=IF(ISNA(VLOOKUP(A7,Sheet2!A4:H21,3,FALSE)),"",VLOOKUP(A7,Sheet2!A4:H21,3,FALSE))
 

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

Top