Lookup based on certain condition

Hi Jason.b75

The formula you mention to enter in "productivity" cell B11 down - I CANT do that as that's the input from the system.

I placed this formula
=IFERROR(MATCH(1E+100,H11:AS11),)

I assume the above formula should go in column "AZ" in productivity and the array formula then becomes:
{=INDEX(Productivity!$B$11:$B$14,MATCH(TRUE,IF(Productivity!$E$11:$E$14=D12,Productivity!$AZ$11:$AZ$14=MAX(IF(Productivity!$E$11:$E$14=D12,Productivity!$AZ$11:$AZ$14))),0))}

is that correct? thxs