Skipping Data in Excel

Hello Experts,

To postulate this relatively simple issue i am going to use an example:

Let us assume that in Sheet 2 the required data is the the following cells: C4,H4,M4,R4......etc

I would like to show this data in Sheet 1 A1,B1,C1,D1.......etc

I have tried to input the first 3 cells manually, and dragging the cells, hoping that it would repeat the pattern, but this was useless.

Any tips please using functions?

Try

=INDEX('Sheet 2'!4:4,(COLUMNS($A:A)-1)*5+3)

Don't change the $A:A, it's not related to your data.
The 4:4 is the row # to retrieve data from
The *5 is the interval (every 5th column)
The +3 is the column to begin with (C is the 3rd column)

Hello Jonmo1,

Thanks for the quick reply. Unfortunetly #REF is the anwered obtained. Could you please explain this line: "The 4:4 is the row # to retrieve data from"

Originally Posted by eromlig1991

Could you please explain this line: "The 4:4 is the row # to retrieve data from"

4:4 is how you reference an entire Row (similar to A:A refers to an entire column)..
Your request was asking for references to row 4, in columns C, H, M and R ..

Originally Posted by eromlig1991

in Sheet 2 the required data is the the following cells: C4,H4,M4,R4......etc

The #Ref! Error is likely because your sheet isn't actually named "Sheet 2", as my formula is using..