# Formula help

#### Harquor

##### New Member
Hi there! Just a basic one, I'm sure, but it's driving me NUTS!

I'm trying to copy a formula down from one cell and have it change just the column letter in the next. Here's my formula.
='Month Ends'!N\$52
Next cell should be
='Month Ends'!O\$52
and so on.

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Hi Harquor

In A1:

=INDEX( 'Month Ends'!\$52:\$52,1,ROW()+13)

Hope this helps
PGC

Wow! That was quick!

I'm a little new at excel so adjusting this is beyond me. The cell I'm putting the formula in is F10. Could you tell me how to make the adjustments so I can fill in other cells too?

Thank you!

Hi again

The second parameter of the index tells you the column you are referencing.

Since you want to start at column N that is column 14 (check).

If you started at A1, you were starting at row 1 and so you had to add 13 to get to N.

Now you already start at row 10 so you just have to add 4.

In F10
=INDEX( 'Month Ends'!\$52:\$52,1,ROW()+4)

Remark: You could start in any cell in row 10 and the formula would be the same.

PGC

P. S. Copy down the formula to get the other cells (O52, P52, etc.)

Awesome! Thank you again!

Replies
2
Views
181
Replies
3
Views
478
Replies
7
Views
306
Replies
7
Views
596
Replies
4
Views
245

1,219,096
Messages
6,146,276
Members
450,682
Latest member
augusto89

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back