VLOOKUP #NA Problem Help

[stephen.smith]

Hi guys
I am having a problem with a VLOOKUP Formula. In some cells that I perform the formula I have a #NA result which is fine as there is no result to be found however i just want this cellto be left empty rather than displaying #NA.
How can I do this.
Thanks for any help which can be given.
Stephen

 

[markmzz]

Try one of this formulas:

=IFERROR(VLOOKUP(100,C2:C5,1,FALSE),"")

=IF(ISERROR(VLOOKUP(100,C2:C5,1,FALSE)),"",VLOOKUP(100,C2:C5,1,FALSE))

Markmzz

 

[repairman615]

Hello,

If using 2007 or later, the ifferror function will do:

=iferror(vlookup(your vlookup formula here),"")

add your vlookup formula to replace the red above.



If 2003 an =If(iserror(your vlookup formula),"",your vlookup formula))

-Jeff