Picking up a particular list

I have nine columns of numbers (A through J) with numbered headers on Row 1 of 0 through 9 on worksheet 1. (I've also tried by using "name ranging" the headers (i.e.: ZERO, ONE, TWO, etc).

Each column has a list of numbers up to 50 numbers starting on row 2 down to row 51 (i.e.: A2:A51, etc).

On worksheet 2 I've used the following coding using numbers in the coding:

A1 is where I put a number (let's say 2).

I'm wanting the entire associated list of numbers from Worksheet 1 Column C to appear starting A2 down to A51.

=IF($A$1>0,OFFSET(CHOOSE('FINAL SORT'!$A$1,0,1,2,3,4,5,6,7,8,9),ROW()-2,0))

Also tried by name ranging the Row 1 header:

=IF($A$1>0,OFFSET(CHOOSE('FINAL SORT'!$A$1,ZERO,ONE,TWO,THREE,FOUR,FIVE,SIX,SEVEN,EIGHT,NINE),ROW()-2,0))

I've also tried as an array and just as a straight copy down.

And all I get is a #VALUE!

What have I missed in the coding?

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

In A2:

=INDEX(Sheet1!$A:$J,ROW(),MATCH($A$1,Sheet1!$A$1:$J$1,0))

copied down

in C2:

=INDEX('ALT Sheet1'!$A:$J,ROW(),MATCH($C$1,'ALT Sheet1'!$A$1:$J$1))

copied down

Format all the cells as custom: 0;-0;;@