Align 2 Tables, Match Two Outputs From A Database

My goal is to match two outputs from a database so that the same person's record can be found on one row. At present output 2 does not marry up to output 1 due to staff leaving and new appointments being made. The data in output 1 should remain static. The data in output 2 must be manipulated to match the order of output 1.

Output 1 is a 5 column record containing (in A6:E6)

Forename, Surname, Branch, Roll Number, and a % score

Output 2 is again a 5 column record containing (in G6:K6)

Forename, Surname, Branch, Roll Number, and a % score

Each employee can be identified by a unique Roll Number Code contained in the fourth column of each record.
If an ideal match has been found I'd like the letter Y to be inserted in the L column of each record to signify a positive comparison. All non matches should have the letter N in the L column & these non matches should be placed at the bottom of the dataset.