How to get VLOOKUP to return zero is not found???

Originally Posted by DonkeyOte

A couple...

=IF(ISNA(VLOOKUP(....)),0,VLOOKUP(....))

or assuming results of VLOOKUP when found are numeric then another alternative:

=LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,VLOOKUP(...)))

I don't even understand your answer, I guess my vast lack of knowledge is more than showing.
My current formula is:
=VLOOKUP(C1,'IMPORT-A'!A:H,3,0)
If not found I would like the result to be 0(zero).

Please forgive my ignorance.