Vlookup formula returning #N/A

I'm using the formula below and prefer to use it in that format. However, when it doesn't find what the criteria is, it returns a #N/A. This in turn it also messes up my subtotal formulas...


Formula: =IF(B155="","",VLOOKUP(B155,'ITO Sink'!$AL$4:$HH$199,105,0))

What can I do to avoid these issues? Can the existing formula be modified to return a zero vs. #N/A? Or is it as simple as somehow modifying the subtotal formula? Solutions?


Thanks

Which version of Excel are you using.

XL2007+ you can use IFERROR
=IFERROR(IF(B155="","",VLOOKUP(B155,'ITO Sink'!$AL$4:$HH$199,105,0)),0)