Index & Match to pick out 'all' the data values in a 'specified" column of data

Dear Forum colleagues:

(Using Excel 2016)

I wish to obtain a range of values from a 'specific' column in a range of columns, using a unique user number, from a Validation List, to display data in the specified column header.
I can pick out "User Name" with the INDEX Function but, I cannot seem to automate MATCH Function to allow cells below the User Name to be displayed.

I have allotted a Range Name to the specific Data namely; Rng_Matrix, on the Data Worksheet.

Attached is an example file - Example01

Enter

Formula:

Please Login or Register  to view this content.

in C3
Select C3:c28 and commit the formula in the formula bar with Ctrl+Shift+Enter

( the double comma is not a typo)

Put this formula in C3 of the Charts sheet:

=INDEX(Rng_Matrix,ROWS($1:1),MATCH(C$2,Data!$B$2:$S$2,0))

then copy down.

Hope this helps.

Pete

Arthur and Pete:

Both your CSE Array solutions worked brilliantly. I can now help another team member to understand the figures.
I am retiring at the end of July. I will be 69. But, I want to say a big thank you; Arthur, Pete and other Excel Forum members for their help over the years. It's individuals like yourselves who are invaluable in helping others obtain solutions to tricky problems. Thank you so much !!!
I'll add a comment to your reputations and mark the thread as 'Solved'. Thank you - David Roper.

You're welcome (I am 70 since last month)

Arthur:

Deiner arbeit ist "Ausgezeichnet ! My mother was an Austrian.

Glad to help, David, and thanks for the rep and kind words.

My formula does not have to be committed by CSE, however - it is normally-entered.

Good luck for your retirement (I've been retired for 6 years)

Pete