I have a workbook called 'QSMA12_16'.
I have about 30 or so worksheets in this workbook (one for each student who does the subject ... plus a few other necessary sheets, like 'Synergetic Transfer').
In the worksheet called 'Synergetic Transfer' in cell range A4:A33 I have each of the students ID numbers. In cell range B4:B33 I have each of their names.
In cell range C4:C33 I'd like to have returned their particular result for an assessment item. Each student will have this particular result found in their particular worksheet in cells DK10 and DK11.
So I need a formula in 'Synergetic Transfer!C4' that will look at the student name in cell B4, then look for the worksheet with that same student name, and return the concatenation of cells DK10 and DK11 from that particular student's sheet.
I suspect it will need the function 'INDIRECT' but I don't know how to put it together.
Is it possible ?
Chris
I have about 30 or so worksheets in this workbook (one for each student who does the subject ... plus a few other necessary sheets, like 'Synergetic Transfer').
In the worksheet called 'Synergetic Transfer' in cell range A4:A33 I have each of the students ID numbers. In cell range B4:B33 I have each of their names.
In cell range C4:C33 I'd like to have returned their particular result for an assessment item. Each student will have this particular result found in their particular worksheet in cells DK10 and DK11.
So I need a formula in 'Synergetic Transfer!C4' that will look at the student name in cell B4, then look for the worksheet with that same student name, and return the concatenation of cells DK10 and DK11 from that particular student's sheet.
I suspect it will need the function 'INDIRECT' but I don't know how to put it together.
Is it possible ?
Chris
