Hi guys,

I am hoping someone can have me come up with a formula:

It might be best to lay it out so here is what my spreadsheet looks like:

ID Amount ID Amount
1234 $100 4213 $80
2134 $80 1234 $100
3124 $120 2134 $80
4213 $100 4412 $60

If it helps, I am doing a reconciliation. Essentially, if the ID exists in both lists and is the same, then it's fine and nothing needs to happen (in the above example, that would be for ID 1234 and 2134). However, if an ID is only on one list or if the amounts are not equal, I want it to be flagged.

I was trying to do two separate vlookups and then compare but I have been left scratching my head. Can anyone suggest any ideas on what the best approach is?

Your help would be greatly appreciated.

Thanks!