Copy-Paste question

Hi,

Is this what you are trying to achieve ?

Punnam

Not exactly. I'm doing a horrible job at explaining.

I have significant amount of rows that I want to reference to a different sheet that moves horizontally.
Here's the actual formula I'm using (it really isn't the formula itself I want to change).


Column A is a list of Users

B2: =IFERROR(INDEX('Player Predictions'!D$3:D$84,MODE(MATCH('Player Predictions'!D$3:D$84,'Player Predictions'!D$3:D$84,0)+{0,0})),"")
B3: =IFERROR(INDEX('Player Predictions'!G$3:G$84,MODE(MATCH('Player Predictions'!G$3:G$84,'Player Predictions'!G$3:G$84,0)+{0,0})),"")
B4: =IFERROR(INDEX('Player Predictions'!J$3:J$84,MODE(MATCH('Player Predictions'!J$3:J$84,'Player Predictions'!J$3:J$84,0)+{0,0})),"")

I want to keep this pattern going down column B without having to manually change the reference columns. It goes D, G, J, (keep pattern from here) M, P, S, etc.
When I try to copy-paste the pattern it repeats it.

Can you give me exact relation between User 1 to Data 1 .
I mean the actual data as per your table.

Punnam