#N/A on VLOOKUP

[Shawn]

Is there a way to have the VLOOKUP return a 0 instead of
an #N/A if the look up value is not available while
looking for an exact match?

Thanks,

Shawn

 

[Andy B]

Hi

Use something like this:
=IF(ISNA(your formula),0,your formula)

 

[Peo Sjoblom]

=IF(ISERROR(MATCH(A2,B2:B50,0)),0,VLOOKUP(A2,B2:C100,2,0))

 

[Alan]

=IF(ISNA(VLOOKUP(A1,B1:B20,2,FALSE)),0,VLOOKUP(A1,B1:B20,2,FALSE))