Vlookup #NA


A

Aardvark

Dear all,

I have a working Vlookup table, however until I enter a lookup value the
spreadsheet returns an #NA value. IS there any way of hiding the #NA?

Thanks,

Danny
 
Ad

Advertisements

D

Dave Peterson

=if(iserror(vlookup(...)),"",vlookup(...))

would be one way.
 
G

Gord Dibben

Danny

=IF(ISNA(VLOOKUP(I2,G1:H12,2,FALSE)),"",VLOOKUP(I2,G1:H12,2,FALSE))

Gord Dibben Excel MVP
 
Ad

Advertisements

M

Michael J. Connell

Aardvark,

You can us the logic of an "IF" statement - I have used this in the past
when I want to formulate a cell only when a value falls into the cell.
Until that time, I would use

'=if(A5 = "","",Vlookup(x,y,z))'
where A5 = someother cell you link to the Vlookup (most
probably x in the syntax)

Reads - if another cell you use to link to the Vlookup equals nothing,
than show nothing in this cell, however, if there is something in the
cell prompting your Vlookup, than perform the actual Vlookup function in
this cell.

Hope this helps
MJC
 

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

#NA Problem using VLOOKUP 1
Most formulae replaced by #NA 10
#NA in remote reference formula 6
How to make #NA appear blank? 2
How to give a value to NA in Excel 3
VLookup 6
VLOOKUP 1
Vlookup 5

Top