#N/A

  • Thread starter Thread starter Eric H
  • Start date Start date
E

Eric H

I am running a VLOOKUP formula, where I am getting a lot of #N/A becuase I
don't have supporting information from the table I am looking up from.

How can I rid the #N/A. Is there something in Conditional Formatting I can
do to at least "hide" the #N/A?
 
For a blank cell use:
=If(ISNA(your lookup formula),"",your lookup formula)

Replace the < "" > with whatever you wish to see displayed in the formula
cell in place of the #N/A error.
 
thank you

Ragdyer said:
For a blank cell use:
=If(ISNA(your lookup formula),"",your lookup formula)

Replace the < "" > with whatever you wish to see displayed in the formula
cell in place of the #N/A error.
Click to expand...
 
Just FYI... Excel 2007 has a new function called IFERROR that is useful in
this circumstance.

=IFERROR(VLOOKUP(C1,A1:B5,2,FALSE),"")

Here, the result of VLOOKUP is displayed if it does not cause an error. If
it does cause an error, an empty string is returned.

--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top