software

If I do a VLOOKUP and the resulting answer is #N/A, how can I get the result
to show as a zero (0) instead?

=IF(ISNA(quot;your vlookup herequot;),0,quot;your vlookup herequot;)
or
=IF(ISERROR(quot;your vlookup herequot;),0,quot;your vlookup herequot;)

--
Carlos

quot;Jayequot; gt; wrote in message
...
gt; If I do a VLOOKUP and the resulting answer is #N/A, how can I get the
result
gt; to show as a zero (0) instead?
You can wrap your VLOOKUP formula in an IF statement, like.....

=IF(ISNA(YourVlookupFormula),0,YourVlookupFormula)

Vaya con Dios,
Chuck, CABGx3
quot;Jayequot; wrote:

gt; If I do a VLOOKUP and the resulting answer is #N/A, how can I get the result
gt; to show as a zero (0) instead?

Hi!

Try this:

=IF(ISNA(your_vlookup_here)),0,your_vlookup_here))

Biff

quot;Jayequot; gt; wrote in message
...
gt; If I do a VLOOKUP and the resulting answer is #N/A, how can I get the
gt; result
gt; to show as a zero (0) instead?
Hi, Chuck!! Thanks for your help. Worked perfectly.

quot;CLRquot; wrote:

gt; You can wrap your VLOOKUP formula in an IF statement, like.....
gt;
gt; =IF(ISNA(YourVlookupFormula),0,YourVlookupFormula)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Jayequot; wrote:
gt;
gt; gt; If I do a VLOOKUP and the resulting answer is #N/A, how can I get the result
gt; gt; to show as a zero (0) instead?