Match/Index Function with use of Max

[nrc0710]

I feel like this is relatively easy to solve, but I’m probably overthinking the solution. What would the formula need to be to get the information for H5 & I5?

 

[Cubist]

Try:

Book1 (version 2).xlsb
	A	B	C	D	E	F	G	H	I
1
2
3		2012	J	36
4		2013	C	17
5		2014	M	25			2015	M	39
6		2015	W	10
7		2012	H	19
8		2013	W	25
9		2014	Z	30
10		2015	M	39
Sheet9

Cell Formulas
Range	Formula
H5:I5	H5	=TAKE(SORT(FILTER(C3:D10,B3:B10=G5),2),-1)
Dynamic array formulas.

 

[nrc0710]

Try:

Book1 (version 2).xlsb
	A	B	C	D	E	F	G	H	I
1
2
3		2012	J	36
4		2013	C	17
5		2014	M	25			2015	M	39
6		2015	W	10
7		2012	H	19
8		2013	W	25
9		2014	Z	30
10		2015	M	39
Sheet9

Cell Formulas
Range	Formula
H5:I5	H5	=TAKE(SORT(FILTER(C3:D10,B3:B10=G5),2),-1)
Dynamic array formulas.

Perfect!!! Thank you!

 

[Cubist]

Perfect!!! Thank you!

You're welcome.