Totally non banding help needed! I need to copy a formula in Excell from one cell into 300. However, part of the formula needs to remain constant whilst part increments by one in each line - here's the problem: In Column A, we have a text description. In Column B we need to work out the equivalent code for that text. I am using lookup to do this rather than a load of nested IF statements as I have more than 7 possibilities! The options are listed elsewhere in the tabe in columns f2:f30 with corresponding codes in g2:g30 Here's the problem: The formula currently reads =LOOKUP(A2,f2:f30,g2:g30) when in the appropriate cell in line 3, it needs to read: =LOOKUP(A3,f2:f30,g2:g30) and for line 4 =LOOKUP(A4,f2:f30,g2:g30) If I use paste then all of the numbers increment and I get =LOOKUP(A3,f3:f31,g3:g31) and so on. Any excel geniuses out there who have any tips will be rewarded with beer when we next meet at a contest!