Hi, Excel experts. Directly to the point:
I need to find if the DisplayName matches with Payroll_Last AND any of the other two (Payroll_Second, Payroll_Name). If match, write "MATCH" in E.
<tbody>
DisplayName
Payroll_Last
Payroll_Second
Payroll_Name
Ross Eustace Geller
GELLER
ANYSECOND...