J
Jaye
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?
to show as a zero (0) instead?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CarlosAntenna
=IF(ISNA("your vlookup here"),0,"your vlookup here")
or
=IF(ISERROR("your vlookup here"),0,"your vlookup here")
or
=IF(ISERROR("your vlookup here"),0,"your vlookup here")
C
CLR
You can wrap your VLOOKUP formula in an IF statement, like.....
=IF(ISNA(YourVlookupFormula),0,YourVlookupFormula)
Vaya con Dios,
Chuck, CABGx3
=IF(ISNA(YourVlookupFormula),0,YourVlookupFormula)
Vaya con Dios,
Chuck, CABGx3
B
Biff
Hi!
Try this:
=IF(ISNA(your_vlookup_here)),0,your_vlookup_here))
Biff
Try this:
=IF(ISNA(your_vlookup_here)),0,your_vlookup_here))
Biff
J
Jaye
Hi, Chuck!! Thanks for your help. Worked perfectly.