Hi Jafro:
Let us regroup here now and take stock of things first before we proceed. Let us verify what you have stated earlier ...
1. The workbook you are working with is SeviceCalc.xls
2. Your lookup table is in a worksheet called Tables that is in ServiceCalc.xls and the table covers the range AB5:AC9
3. You want to use the VLOOKUP formula in a worksheet called House, that is also in the workbook ServiceCalc.xls
4. Your lookup value is in cell D3
5. You want to write VLOOKUP formula in cell G9 of the worksheet House
So questions, before we talk about your new, changed formula in your last post, did you use emulate the formulation in my post that was based literally on every detail according to your specification.
If you have not tried that try that first, so you can see how the VLOOKP formula works -- and once you have understood that, then you can try some variations of that formulation.
If you have tried that, and it did not work for you -- what did not work -- did you work with everything you had specified?
You should also consider posting your data and the result you got using Colo's Cool utility, downloadable from MrExcel page -- and then let us take it from there.