If your turn the ID entries in both sheets into text entries, so that 1.1 is not the same as 1.10 (when entered as number), then you can use formula in N2:
=INDEX(Evaluation!Q:Q,MATCH(B2,Evaluation!A:A,0))
copied down and in O2
=INDEX(Evaluation!P:P,MATCH(B2,Evaluation!A:A,0))
copied down.
Then you will be able to sort by those 2 columns.
|