I have this badboy of a formula:
=INDEX(Dashboard!$F$4:$F$5069,MATCH(1,INDEX((LARGE(IF(Dashboard!$A$4:$A$5069=A28,Dashboard!$T$4:$T$5069),1)=Dashboard!$T$4:$T$5069)*(Dashboard!$A$4:$A$5069=A28),),0))
Ignoring the ins-and-outs of it, it does an Index:Match lookup on the Largest value of a...