# Help with INDEX function and dragging formulas

##### New Member
Hi MrExcel community,

I'm new to the forum and also not an experienced user of Excel - trying to get my way around it though.

I have the following problem to be solved, tried some research with no success. This is the simplification of the actual issue I have but if I'm able to do what I will explain below, I can solve my real issue. Please refer to the table.

Column A is formed by a combination of elements from column D and a fixed value Z (which in the example is located in F4).

In order to create column A, what I have been trying to do is to look elements up using INDEX, so that A1 receives =INDEX(D\$1:D\$7, 1), A2 receives F\$4 and subsequently, A3 =INDEX(D\$1:D\$7, 2), A4 = F\$4...

If I try to drag the formula down using 6 cells with that logic it doesn't work - I was expecting the second argument inside INDEX to increment but it doesn't. Dragging these cells down just repeat them.

What can be done to solve this?

 A B C D E F 1 A A 2 Z B 3 B C 4 Z D Z 5 C E 6 Z F 7 G 8 H

<tbody>
</tbody>

### Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

#### steve the fish

##### Well-known Member
Hi. Try:

=IFERROR(IF(MOD(ROWS(\$A\$1:A1),2),INDEX(\$D\$1:\$D\$8,ROUNDUP(ROWS(\$A\$1:A1)/2,0)),\$F\$4),"")

Replies
3
Views
1K
Replies
5
Views
389
Replies
7
Views
1K
Replies
4
Views
355
Replies
3
Views
258

1,190,878
Messages
5,983,366
Members
439,841
Latest member
goodwillhunting

### 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