How to get rid of #n/a

C

Curtis

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.
 
M

Max

= 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

Similar Threads

How to correct a #N/A in vlookup 1
Multiple IF Statement 2
Get rid of Microsoft AutoUpdate 0
Nested If with VLookup result a 0 8
Vlookup problem 5
Use multiple sheets to display and edit data? 0
"IF" help 3
Word 2007 flash screen upside down and Word2007 cannot be used 0

Top