Formula will not increment

[gregork]

I want to apply a formula to all cells in a column on a sheet.
But when I drag it down the number I want to increment for each cell will
not increment. Here is the formula:
=HLOOKUP($O$1,A$2:BL$1002,2,FALSE) ..the number I want to increment is ,2
This number is for the row in my lookup. I'm thinking the problem may be
because this formula is on a cell in row 3 of my sheet.
I would change it manually on each cell but I would have to do this about
300 times!

Cheers
gregK

 

[Max]

Assume you want to increment the 3rd param of HLOOKUP
as you copy down the col, viz: 3, 4, 5, 6 ... etc

Try instead in the starting cell in row3 (from your post)
: =HLOOKUP($O$1,A$2:BL$1002,ROW()-1,FALSE)

Now when you copy the formula down the col,
the ROW()-1 part in the formula will give you
the increment desired

 

[Max]

sorry, small typo corrections:

Assume you want to increment the 3rd param of HLOOKUP
as you copy down the col, viz: 3, 4, 5, 6 ... etc

should read as:

Assume you want to increment the 3rd param of HLOOKUP by "1"
as you copy down the col from the starting cell in row3, viz: 3, 4, 5, 6

.... etc

 

[gregork]

Many thanks Max..Your solution works perfectly.

Regards
gregK

 

[Max]

You're welcome, gregK !
Glad to have helped.

cheers
Max