Alternating Columns Refrence

[Chase187]

I am trying to reference numbers from a data sheet in my excel doc. I need numbers from the same row but alternating columns. Copying the formula downward would result in the following cell references..

A1 -- Data!B4
A2 -- Data!D4
A3 -- Data!F4
A4 -- Data!H4

etc. Any help is appreciated. Thank you.

 

[steve the fish]

Hi. This should work:

=INDEX(Data!$4:$4,2*ROWS($A$1:A1))

 

[Joe4]

Welcome to the Board!

Another option:

=OFFSET(Data!$B$4,0,(ROW()-1)*2)

 

[Chase187]

file:///Users/Chas/Desktop/Screen%20Shot%202018-04-27%20at%2011.35.52%20AM.png

Hopfully this link to a screenshot of my data will work. I am trying to sort the data by the score column smallest to largest. I have tried a custom sort of the score column, values, smallest to largest. It will not change the arrangement of the data. Does anyone know why I am having issues?