#N/A error

[Guest]

I'm using the VLOOKUP formula. Because some numbers are not found, the cell
shows error #N/A. Using a formula, is there any way the cell can return 0
instead #N/A?

 

[Guest]

=IF(ISERROR(VLOOKUP([your vlookup])),0,VLOOKUP([your vlookup]))

Dave

 

[Alan]

Something like
=IF(ISNA(VLOOKUP(E3,A1:B100,2,FALSE)),0,VLOOKUP(E3,A1:B100,2,FALSE))
Regards,
Alan.

 

[Guest]

thanks for making my day easier. have a nice weekend!

 

[Gord Dibben]

=IF(ISNA(VLOOKUP(H1,B1:F28,2,FALSE)),0,VLOOKUP(H1,B1:F28,2,FALSE))


Gord Dibben MS Excel MVP