I have two sheets in one work book and I'm trying to figure out the following:
An ID on the sheet has the same amounts in column C, E, and H
So column A, on both sheets, contains the ID.
Column B contains code AAA on both sheets
Column D contains TTTT or HAA on both sheets
Column G contains ZZZZ or BBB on both sheets
I need to figure out if all the amounts match the ID/codes in the columns and if the don't I need to know which amount column is different.
As an example,
I know that Sheet 1 and 2 do not match in C4. I need to know this amount doesn't match when A4 and B4 both match. I also need to know if D&E and G&H match for A4.
I hope that makes sense.
I was thinking of combining an if statement with an index match, but I'm having difficulty trying to figure out how.
Bookmarks