We want to populate the Final Mark (Round up) column using data from another worksheet
The Xlookup formula is the best way to do this. it lets us take a value from one worksheet and look up (find) the matchig value in any column
in another worksheet and then return a vlaue from the same row in another column.
In this example we are reading the ID number from cell C2 and then finding that ID number is column D in a 2nd worksheet called Loading and
returning the Final Mark (Round up) from Column Q.
=XLOOKUP(C2,loading!$D:$D,loading!$Q:$Q)
The loading tab contains the following data: we are only interested in Column D which contains the student numbers and column Q withic contains the Final Mark (Round up).
What can you do with XLOOKUP in Excel? from Excel: VLOOKUP and XLOOKUP for Beginners by Jess Stratton