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.

Originally Posted by DonkeyOte

In the first suggestion simply replace the references to VLOOKUP(...) with your own VLOOKUP, ie:

=IF(ISNA(VLOOKUP(C1,'Import-A'!A:H,3,0)),0,VLOOKUP(C1,'Import-A'!A:H,3,0))

Note: given you're pulling Column C you need not reference A:H you could just reference A:C thereby reducing dependencies... you could use INDEX/MATCH to reduce further but that's for another day.

My formula:
=IF(ISNA(VLOOKUP(A2,'Import-A'!A:C,3,0)),0,(VLOOKUP(A2,'Import-A'!A:C,3,0)))
Returns FALSE, how do I get the numeric value at that location to come over if false???

Apparently I thought this solved too soon.

My current formula:
=VLOOKUP(A1,'IMPORT-1'!A:C,3)
no longer returns #N/A when the value in A1 isn't found in IMPORT-1 but instead returns the previous found value in the same column.

What I need is if not found to get a 0(zero) and if found the value in that cell.

I'm not married to VLOOKUP I just need something that works.

TIA

Thanks, Now I understand what you were previously saying.
Sorry to have bothered you, I shall refrain in the future.