Column A has a list (first and last names) of all users who have an O365 license. Column B has a list of everyone in the company. Column C is associated with Column B and has the job title of everyone in the company.
I want each row in A to check all of B to see if they match. If they match I want to take the corresponding row in column C and copy/paste it into the same row in blank column D
| A (O365 License | B (All Employees | C (Job Title). | D (JobTitle) |
|---|---|---|---|
| John Smith | Jarvis Cobblepott | . IT Guy | |
| Nancy Johnson | John Smith | . Receptionist. | |
| Kevin Gordon | Henry Kissinger | Marketing |
CodePudding user response：
Use ISNUMBER(MATCH()) to see if it exists:
=IF(ISNUMBER(MATCH(B2,A:A,0)),C2,"")
CodePudding user response：
Alternatively maybe:
=XLOOKUP(A2,B$2:B$4,C$2:C$4,"",0)
Or:
=BYROW(A2:A4;LAMBDA(r,X.XLOOKUP(r,B2:B4,C2:C4,"",0)))
