Copying horizontal to vertical based on cell value

[lukestkd]

Hello all,
I have changed the wb slightly from my earlier post, which should make it easier.

In the feedback sheet cell B4 you can select a student. I need it to find the row with the same student name in the 'Marks' sheet, and take the data from B:U (only the one row for student selected) and paste into C7:C26.

Is this possible? wb attachedBTEC Feedback for net.xlsm

Thank you all

[FDibbins]

in C7, copied down, try this...

=INDEX(Marks!$A$1:$U$31,MATCH(Feedback!$B$4,Marks!$A$1:$A$31,0),MATCH(Feedback!B7,Marks!$A$1:$U$1,0))

[lukestkd]

Hi FDibbins,
It works perfectly! I had to change the P1 to U1P1 and U23P1 as it returned the value for the first instance of P1 twice, but after that it does exactly what I need it to!

Many Thanks!!!

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neet and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)