Hello,
I am using Hlookup to get the information from one tab to another the formula i am using is
=HLOOKUP(G51,'FY09 Sheet1'!F54:Q175,4)
The problem is when i drag the formula the row index number doesn't change from 4 to 5 instead i have to change in every row the row index number...