Need to get data from one report into another report:

Two reports €“ one payroll report being used to accurately display the
correct number of people in a retail branch, second report shows only those
in each branch who have completed e-learning or are busy doing it. Second
report is generated by an LMS and only shows those busy with or who have
completed training.

Common variables are employee number and the retail office number (each
employee has its own unique number and each office/retail branch has its own
unique number) have tried to use the retail office number (which is on
both payroll and second report) to get the extra names of those who have not
done e-learning via vlookup but doesnt work €“ as every person in a retail
office shares the same office retail number!!!

Is there a way that I can get those people who are recorded on the payroll
report as being in an office who are not yet on the training report onto the
training report?!?!

Many,many thanks for any help...