Hlook Formula Help

[lcd5502]

Is there a known issue with the following formula in Office 2003
=+HLOOKUP(X$1,'TTT Summary'!$U$6:$AA$92,ROW('TTT Summary'!O3),FALSE)-Z12

I was trying to write a formula that would allow me to insert rows on the TTT summary tab which would change the lookup reference (ROW('TTT Summary.....) in the HLOOKUP formula.

When I try to insert a row on the "TTT summary tab" just above row 3 the row formula does not compensate for that additional row and remains at 3 instead of changing to 4. I have this lookup formula in fow 3 thru 60 in a tab titled "2010 vs 2009". When I try to insert a row on the "TTT summary tab" just above row 3 the row formula does not compensate for that additional row and remains at 3 instead of changing to 4. However this error only occurs in the first few rows HLOOKUPS. The HLOOKUP in the remainder of rows 7-60 are fine.

Any ideas??

 

[Gerald Higgins]

I tried to replicate this, and failed.

I'm focusing just on the ROW() part of the formula.
I set up a workbook, including a sheet called "TTT summary".
On another sheet, I placed a formula

=ROW('TTT Summary'!O3)

If I inserted a row above O3 on the TTT Summary sheet, the formula on the other sheet changed from O3 to O4.

 

[lcd5502]

Thank you for the response I think I actually figured it out. I had two blank rows above the starting reference row in the lookup range. So wherever I inserted a row the two rows directly below that would not change. I think it is a logic issue with excel.