Forumla Problem

[keilah]

Hi
I have the following forumla =HLOOKUP(ABS($DH$7),$J$7:$CX$4000,2,0)

i do not want to change each value i.e. the number 2 all the way to 4000,,,,,

can i drag the cursor and do this or is there another way of repeating this step with a different forumla.

regards

[Bob Phillips]

=HLOOKUP(ABS($DH$7),$J$7:$CX$4000,ROW(A2),0)

[keilah]

thanks...........

[rory]

It's hugely inefficient to look up the same value 4000 times, by the way. You would be better off using one MATCH formula to get the column number you want and then just using that value to return data from the relevant rows.