EXCEL (Advanced): Match Two Accounting Lists

Hi all

I have two purchase trackers for a project I am working on, from different departments - List 1 and List 2. I need the cost values and cost codes to match for each item on them. I need someone to correct List 2 and record what has been changed to make it match List 1.

Annoyingly, they are in different formats on Excel (image examples attached) - so it's not as easy as highlighting duplicates and requires some manual work.

The lists are long - List 1 is approx 3200 lines.

There are some reference numbers that can be used to compare the lists, but some of it will be manually going through and trying to find the same purchased item on both lists and check the amounts match.

Feel free to message with me questions, as I realise this is quite vague.

Thanks,
Jake