Forum Discussion
Match First + Last Name, then compare Salary
Hello! I am wondering how I can first match first and last names across two different worksheets, then compare their salaries and have the column say true/false if they do not match. Example: Work...
Assuming that there are no duplicate combinations of first name/last name:
In D2 on Worksheet 2:
=SUMIFS('Worksheet 1'!$C$2:$C$1000, 'Worksheet 1'!$A$2:$A$1000, $A2, 'Worksheet 1'!$B$2:$B$1000, $B2)=$C2
Change Worksheet 1 to the real name of that sheet, and adjust the ranges if the data on the first sheet extend below row 1000.
Then fill down.