Find strings within several cells

[Panchistiko]

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.

[TABLE="width: 615"]
<tbody>[TR]
[TD="align: center"]DisplayName
[/TD]
[TD="align: center"]Payroll_Last[/TD]
[TD="align: center"]Payroll_Second[/TD]
[TD="align: center"]Payroll_Name[/TD]
[/TR]
[TR]
[TD="align: center"]Ross Eustace Geller[/TD]
[TD="align: center"]GELLER[/TD]
[TD="align: center"]ANYSECOND[/TD]
[TD="align: center"]ROSS EUSTACE[/TD]
[/TR]
[TR]
[TD="align: center"]Rachel Green[/TD]
[TD="align: center"]GREEN[/TD]
[TD="align: center"]SECOND[/TD]
[TD="align: center"]RACHEL KAREN[/TD]
[/TR]
[TR]
[TD="align: center"]Joey Francis Tribbiani Jr.[/TD]
[TD="align: center"]TRIBBIANI[/TD]
[TD="align: center"]JR[/TD]
[TD="align: center"]JOSEPH JOEY FRANCIS[/TD]
[/TR]
[TR]
[TD="align: center"]Monica E Geller[/TD]
[TD="align: center"]GELLER[/TD]
[TD="align: center"]BING[/TD]
[TD="align: center"]MONICA MIDDLEE[/TD]
[/TR]
[TR]
[TD="align: center"]Chandler Muriel Bing Bing[/TD]
[TD="align: center"]BING[/TD]
[TD="align: center"]BING[/TD]
[TD="align: center"]CHANDLER MURIEL[/TD]
[/TR]
[TR]
[TD="align: center"]Phoebe Buffay[/TD]
[TD="align: center"]BUFFAY[/TD]
[TD="align: center"]NOSECOND[/TD]
[TD="align: center"]PHOEBE NOMIDDLE[/TD]
[/TR]
</tbody>[/TABLE]

Thank you.

 

[Panchistiko]

I'm so sorry. I've already asked this three years ago.
I can't believe I have to do the same job again. Can I close this thread?

This is the post, if any is interested.