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...
The HansVogelaar solution using SUMIFS looks good. I set out to use XLOKUP with 365 and got to
= MAP(firstNameWS2,surnameWS2,SalaryWS2,
LAMBDA(fName,sName,salary,
XLOOKUP(1, (firstNameWS1=fName)*(surnameWS1=sName),SalaryWS1) = salary
)
)It returns the entire column with one formula but so would
= SUMIFS(
SalaryWS1,
firstNameWS1, firstNameWS2,
surnameWS1, surnameWS2)
= SalaryWS2once I converted the salaries to numbers.