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.

DisplayName	Payroll_Last	Payroll_Second	Payroll_Name
Ross Eustace Geller	GELLER	ANYSECOND	ROSS EUSTACE
Rachel Green	GREEN	SECOND	RACHEL KAREN
Joey Francis Tribbiani Jr.	TRIBBIANI	JR	JOSEPH JOEY FRANCIS
Monica E Geller	GELLER	BING	MONICA MIDDLEE
Chandler Muriel Bing Bing	BING	BING	CHANDLER MURIEL
Phoebe Buffay	BUFFAY	NOSECOND	PHOEBE NOMIDDLE

<tbody>
</tbody>

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.