Vlookup #NA

  • Thread starter Thread starter Aardvark
  • Start date Start date
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
 
Danny

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

Gord Dibben Excel MVP
 
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
 
Back
Top