#N/A

[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?

 

[Ragdyer]

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.

 

[Teethless mama]

=IF(ISNA(your_formula),"",your_formula)

 

[Eric H]

thank you

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.

 

[Chip Pearson]

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)

 

[RagDyer]

You're welcome, and thanks for the feed-back.