10.6 Sort by specified order

 

Here below is a data table:

imagepng imagepng

Please add one column Score on the right of the column Name in the Student sheet, and fill in the data of column Score of the Score sheet in the added column. Calculate in cell C1 of Student sheet:

A
1 =E(‘A1:B17’)
2 return E(‘Score!A1:B12’).align(A1:Name,Name).new(~.Score)

imagepng