Hi again,

My apologies. So used to returning null if not found I did it in the
formula. Should be following to return zero if not found:

=IF(ISNA(VLOOKUP(C2,$A$2:$B$20,2,FALSE)),0,VLOOKUP (C2,A2:B20,2,FALSE))

--
Regards,

OssieMac


"Fitzi" wrote:

I am using the vlookup function. I want it to look up an exact match then
return the number zero if it does not find a match instead of #N/A.

Can you help?