Reverse Lookup/Index and Return Column Headers

[FuriousD]

I've posted a similar request previously but wasn't able to get the formula figured out, but was able to get on the right track and create a solution. Hoping someone can help as now I have an issue with Duplicates and need a way to return the column headers for like 30,000 lines of data. Sample below:

	A	B	C	D	E	F	G	H	I
1	ID	Employee	Manager	Recruiter	Rec Asst	HM Asst	Task Name	Task Completed By	Role Who Completed Task
2	123	Jane Young	Kenny G	LL Cool J	Dave Grohl	LL Cool J	Emergency Contact	Jane Young	Employee
3	123	Jane Young	Kenny G	LL Cool J	Dave Grohl	LL Cool J	Employer I9	LL Cool J	Recruiter
4	125	John Old	Dr. Dre	Dr Dre	Dr. Dre	Dr Dre	Confirm Start Date	Dr. Dre	Manager

So I need Column I to return an index of the Headers from the Array B1:F1 to show me which person completed the task. However you see there are duplicates in Column D and F in this example. There could be duplicates in all 4 business roles (not employee) potentially.

I'd like to incorporate something like an IFS statement so that it evaluates from left to right. So if the Manager Name = the Task Complete by Name (H), then it returns Manager before it evaluates the others for a match.

Any ideas? TIA

 

[steve the fish]

Could do this:

=INDEX($B$1:$F$1,MATCH(H2,B2:F2,0))

 

[FuriousD]

Could do this:

=INDEX($B$1:$F$1,MATCH(H2,B2:F2,0))

Awesome, thanks. I was waaaaay overcomplicating it.