Making N/A become a zero
 

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?

Making N/A become a zero
 

=IF(ISNA("your vlookup here"),0,"your vlookup here")
or
=IF(ISERROR("your vlookup here"),0,"your vlookup here")

--
Carlos

"Jaye" wrote in message
...
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?

Making N/A become a zero
 

You can wrap your VLOOKUP formula in an IF statement, like.....

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

Vaya con Dios,
Chuck, CABGx3



"Jaye" wrote:

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?

Making N/A become a zero
 

Hi!

Try this:

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

Biff

"Jaye" wrote in message
...
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?

Making N/A become a zero
 

Hi, Chuck!! Thanks for your help. Worked perfectly.

"CLR" wrote:

You can wrap your VLOOKUP formula in an IF statement, like.....

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

Vaya con Dios,
Chuck, CABGx3



"Jaye" wrote:

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?