#N/A
 

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?

#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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Eric H" wrote in message
...
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?

#N/A
 

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


"Eric H" wrote:

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?

#N/A
 

thank you

"Ragdyer" wrote:

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Eric H" wrote in message
...
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?

#N/A
 

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)



"Eric H" wrote in message
...
thank you

"Ragdyer" wrote:

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Eric H" wrote in message
...
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?

#N/A
 

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Eric H" wrote in message
...
thank you

"Ragdyer" wrote:

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Eric H" wrote in message
...
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?