Arranging two different columns in same order

[TrevorMalcolm]

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.

[Bhuvi]

Hi,
Welcome to the forum

it seems like you have to match the invoice nos. in column A and Col F (original listing). You must learn to use vlookup or index & match functions to achieve the result.

for now I have put the formula in col D & E after replacing dots. where you got values other than #NA are the matching entries.

I hope I understood you correctly

[TrevorMalcolm]

must be aligned.xlsxThank you Bhuvi, really appreciate you help here.
But what i really need is to try and align the two columns, filling in with blank spaces when there is one number missing in one column vs the other.
I have tried to insert this code as explained here, but with no joy.
http://stackoverflow.com/questions/1...-rows-in-excel
http://www.ozgrid.com/forum/showthread.php?t=175524

one more step.xlsx