Hi Richard,

Try this utility which l wrote some time ago.

It matches records in 2 lists by the value of the leftmost column in
each record. Where a matching record cannot be found a blank cell is
inserted.

Please let me know how you get on with it as l am planning to publish
it as an add-in.

Link:

http://www.excelexperts.co.uk/testweb.htm

It is on the downloads page and is called 'Match 2 Lists'

Regards

Michael Beckinsale