ID lookup for Max Value in a given 'category'

Originally Posted by ChemistB

Arrayed function
In H10 dragged down

=INDEX($A$2:$A$16,LARGE(IF($B$2:$B$16=G10,ROW($B$2:$B$16)-1,0),1))

In H28
=INDEX($A$20:$A$34,LARGE(IF($B$20:$B$34=G28,ROW($B$20:$B$34)-19,0),1))
Does that work for you?

It does! Now I need to parse what you're doing there...

THANKS!!