Display Highest Score Using Vlookup

[jewls567]

I have an employee roster where I am doing a Vlookup using their employee ID from another sheet which has their ID & multiple quiz scores per employee. I'm trying to figure out how to bring over each employee's highest quiz score so that each employee shows the most accurate score. The second sheet may have employees included in the roster that never took the quiz, those that took it once, or those that took it multiple times and have several different scores. What would be the best way to do this? Thank you very much for your help in advance!

 

[Automatrix]

Hard to tell without examples, but I think you're looking for the MAXIFS formula.

 

[Peter_SSs]

I think you're looking for the MAXIFS formula.

MAXIFS Help says it was introduced in Excel 2019 - which the OP does not have.

@jewls567
I have done this in one sheet but you should be able to adapt to 2. If not, or the general layout here is not what you have then please post a small set of sample data and expected results - preferably with XL2BB so that we can easily copy to test with.

jewls567.xlsm
	A	B	C	D	E	F
1	ID	Score			ID
2	ID 1	48			ID 1	48
3	ID 2	54			ID 2	57
4	ID 8	36			ID 3
5	ID 9	55			ID 4
6	ID 5	27			ID 5	27
7	ID 7	60			ID 6	54
8	ID 5	9			ID 7	94
9	ID 7	94			ID 8	36
10	ID 7	90			ID 9	55
11	ID 6	54
12	ID 2	57
Sheet1

Cell Formulas
Range	Formula
F2:F10	F2	=IFERROR(AGGREGATE(14,6,B$2:B$12/(A$2:A$12=E2),1),"")

 

[DanteAmor]

Here another way to consider

Dante Amor
	A	B	C	D	E	F
1	ID	Score			ID
2	ID 1	48			ID 1	48
3	ID 2	54			ID 2	57
4	ID 8	36			ID 3	0
5	ID 9	55			ID 4	0
6	ID 5	27			ID 5	27
7	ID 7	60			ID 6	54
8	ID 5	9			ID 7	94
9	ID 7	94			ID 8	36
10	ID 7	90			ID 9	55
11	ID 6	54
12	ID 2	57
Sheet1

Cell Formulas
Range	Formula
F2:F10	F2	=MAX(IF($A$2:$A$12=E2,$B$2:$B$12))
Press CTRL+SHIFT+ENTER to enter array formulas.