Drag cell to right.. maintain same column values

[Jose Bug]

Hi,

I have a cell that is:
='2019 Run Sheet'!$I48*25
When I drag that cell to the right it becomes:

='2019 Run Sheet'!J48*25

I want it to become:

='2019 Run Sheet'!$I49*25

Anyone know a sneaky way to achieve this?

[Glenn Kennedy]

One way:

=INDEX(Sheet2!$I$148:$I$154,COLUMNS($A:A))

[FlameRetired]

How sneaky did you want it? Tip-toe sneaky or "Give me a break!" sneaky?

=INDIRECT("'2019 Run Sheet'!I"&48+(COLUMNS($J$1:J$1)-1))*25

[Jose Bug]

Thanks peoples, your assistance is greatly appreciated

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.