data display

Please see attached file.

In the file I have 2 tables of data, input from the scan gun (A5: up to E2000) and stock file data (H5: up to M2000)

I have the formulas to compare the ids from both lists and report whether there is a match or a blank call (displayed as end of data) which I ignore and if there is a id not in both lists it shows the ID.

What I need is a way to display this info nicely, preferably showing matching data from the tables.

Any ideas? I did think about a pivot table but didn't seem to work for me. below is an example of the main data I have.

Make a named range ScanID (col B)
Make another named range ScanData (col A to E)

End of stock add a column = match(h2,ScanId,0) (column N)
after this use columns for the "matched data" = index(ScanData,$N2,x) replacing x with 1 to 4 in subsequent columns

Will need an IF statement in column N and with the index function)

(and I haven't had my morning coffee yet so check the order of the parameters)