Returning a zero value

[sheridyn]

Hi - how might I go about getting VLOOKUP or HLOOKUP to return 'zero' instead
of #N/A when there is no value found?

 

[Hee Chee Soon]

Dear Sheridyn,

May be you can try this

=if(isna(vlookup),0,(vlookup))