Vlookup #NA

[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

 

[Dave Peterson]

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

would be one way.

 

[Gord Dibben]

Danny

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

Gord Dibben Excel MVP

 

[Aardvark]

Dear all,

Thanks!

Danny

Danny

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

Gord Dibben Excel MVP

 

[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