Formula that takes account of increments as it is copied across

[The_Snook]

Morning all,

I require a formula that will pull in some costs from another part of the worksheet across a contiguous range but the cells it references are merged in groups of 4 so I will need the formula to accommodate this.

Example attached.

Thanks in advance,

Snook

[samba_ravi]

C6=IFERROR(INDEX($J8:$AC8,COLUMNS($C6:C6)*4-3),"")
Try this and copy towards right

[The_Snook]

Bob on, cheers nflsales!