If you're still having trouble, Excel has a feature that might help.

In Excel 2003, select the cell with the troublesome formula and use:
Tools Formula auditing Evaluate formula
The resulting dialog box walks through the evaluation steps that Excel
uses. Each time you click "Evaluate" Excel does one more step. In this
case, if you click until the argument of INDIRECT(__) is one underlined
string, it'll show exactly the table_array being used for VLOOKUP(). That
should help adjust the table_array's fragments, if needed.