Vlookup-answer value

[adrian]

When using vlookup, if there is no record available for an
answer it returns a #NA result. Can I change this to
report a zero (0) value?

Thanks

 

[Aladin Akyurek]

See for some options:

http://makeashorterlink.com/?J32E23767

 

[Frank Kabel]

Hi
one way:
=IF(ISNA(your_vlookup_formula),0,your_vlookup_formula)