Hi trying to have a certain kind of formula in column E so it can tell me if its a match or not. A & B would have to match C & D or not. Just the ID and amount verse each other.
I can do the formula to match one column verse the other but having a hard time on two columns matches thanks.
I can do the formula to match one column verse the other but having a hard time on two columns matches thanks.
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | ID | Amount | ID | Amount | Forumla Needed | ||
2 | 4 | $ 25.00 | 4 | 25 | Match | ||
3 | 5 | $ 50.00 | 5 | 55 | No Match | ||
4 | 7 | $ 75.00 | 7 | 70 | No Match | ||
Sheet1 |