Hi guys,

First time poster. I have a problem that I think is somewhat complicated. The most difficult thing that I have tried to do with excel. I hope that you guys will be able to help. I have two different reports that I want to compare data on. One report is a master list of numbered accounts and a manager for each account. The other will be a list of transactions for those accounts that will also have an accompanied manager. I want to make sure that the manager matched on the transactions report is the correct manager from the master list. I am hoping to do an if statement that will have an equals sign in it to give me a true/false output. I have devised the following formula, but I think I'm pretty far off. I am thinking another possibility would be an embedded if statement but I am unsure how to do this as well. For simplicity, I have written the formula with the values all on the same sheet.

=IF(A25:A31=E25:E31,C25:C31=G25:G31, UNKNOWN)