Hello, if anybody could help me i'd be really gratefull!

I have two lists. Most of the amounts can be matched off against eachother exactly. Some of the amounts on the second list need to be added together, then they match the first list. Finally, some simply don't reconcile.

Example:

List 1 List 2

£10 £10
£20 £20
£30 £78
£40 £33
£7


Does anybody know how excel can do this? I am having to do it manually, matching the two lists, and it takes hours! Not like in my example