VLOOKUP to return 0 instead of N/A

[vitruvian_man]

This is my formula:

=VLOOKUP($B17,'BY2015'!$A$1:$N$121,2,FALSE)

In some cells it has returned #N/A where it cannot locate a value-I need a 0 returned instead of #N/A

Can someone please help me with this? Let me know what additional information I need to provide.

Thanks for your time and patience.

 

[JoeMo]

If you are using Excel 2007 or a later version:

=IFERROR(VLOOKUP($B17,'BY2015'!$A$1:$N$121,2,FALSE),0)

Excel 2003 or earlier:

=IF(ISNA(VLOOKUP($B17,'BY2015'!$A$1:$N$121,2,FALSE)),0,=VLOOKUP($B17,'BY2015'!$A$1:$N$121,2,FALSE))

 

[vitruvian_man]

You're an absolute lifesaver Joe. I appreciate it very much! Thanks again!