Hey Guys

I was wondering if there was a formula in excel to find the Name (on "Output tab") and the letters (array =Data!C12:BB26)

"T" (Terminated)
"R" (Resigned)
"TR" (Transfer)
"X" (End Temp Assign)

and bring back the End of employment date Date, (array =Data!C11:BB11)

I've attached a sample below.

Sample2.xlsx

Ive attempted a basic index(match) formula but doesnt help me

Thank you