Lookup value in table, return the team header above

[Darren_workforce]

With assistance, I have a formula that returns the supervisor based on the team member name. However, is it possible to reference the team member name and then return the specific team that member is on within the department? I have a cell range with all the team names (P6:P10) but is it possible to reference the agent name, look upwards at the first team header above their name, and return that result?

EX: Bob Smith would be CSR. Wanda Vasquez would be Tier 2.

supervisor lookup:

=IFERROR(INDEX(source!$B$2:$Z$2,1,MIN(IF(source!$B$3:$Z$60=A2,COLUMN(source!$B$2:$Z$2)-1))),"")

 

[Domenic]

That's great, I'm glad I could help.

Cheers!