Need help with an array formula

[tbablue]

{=MAX(IF('[LONG RANGE RESOURCE PLANNER.xls]Resource - DESIGN'!$I$10:$I$870=$B8,IF(ISNUMBER(MATCH('[LONG RANGE RESOURCE PLANNER.xls]Resource - DESIGN'!$M$10:$M$870,{"INV","COMPILE","MP CHECK","MP RE-WRK"},0)),'[LONG RANGE RESOURCE PLANNER.xls]Resource - DESIGN'!$P$10:$P$870)))}

This array formula checks for a unique identifier ~
('[LONG RANGE RESOURCE PLANNER.xls]Resource - DESIGN'!$I$10:$I$870)

Checks if the following text is found ~
MATCH('[LONG RANGE RESOURCE PLANNER.xls]Resource - DESIGN'!$M$10:$M$870,{"INV","COMPILE","MP CHECK","MP RE-WRK"},0))

and returns a corresponding value that meets the criteria ~
'[LONG RANGE RESOURCE PLANNER.xls]Resource - DESIGN'!$P$10:$P$870)

This formula works perfectly at returning the highest value numeric value from column P

Now however, in the cell adjacent I'd like to return the value found in ~
'[LONG RANGE RESOURCE PLANNER.xls]Resource - DESIGN'!$H$10:$H$870) instead

I've tried amending the formula to suit but cant make it work. I think it's because the original array was returning a numeric value (so MAX was wholly applicable) but my new requirement (column H) is a name, a text string.

Can anyone help me? I think SUMPRODUCT may be needed but dont understand how to employ it.

Any assistance welcome.

 

[xld]

=index($q$10:$q$870,min(if($p$10:$p$870=max(if($i$10:$i$870=$b8,
If(isnumber(match($m$10:$m$870,{"inv","compile","mp Check","mp Re-wrk"},0)),$p$10:$p$870))),row($p$10:$p$870)-row($p$10)+1)))