Arranging two different columns in same order

Good morning.
They have past me the task at work to confront 2 different work sheets.
Invoices we issued and sent to our provider, and the invoices they have listed as received, with the amount of each invoice
I have to confront both of them.
The problem is that we have some reference numbers that they do not have listed and vice verse.
In order to confront them i have created all the numbers of possible for both columns.
The problem that i find is that some are duplicates or issued twice to make adjustments. So as soon as I am on row 5 they all start to mismatch and lose there order one against the other one... and obviously this gap gets wider as we go along.
Going one by one, copying and pasting as got me nowhere in 5 hours.

I have added to pages pages to the book. The original version with no fake numbers to try and pair them, and the other one with the full range of possible invoice numbers to try and get match them, with no joy.

Sorry for my English if its not to correct... writing from Spain.
Thank you all.