VLOOKUP question

Copper Contributor

I have a list of names in (B3:B30) and data (little league ERAs) in (J3:J30). Cell J2 gives the lowest ERA for all the players. What do I enter into VLOOKUP to give me a name? I want it to return Dick.

1 column B   ...    column J

2                   ...        0.9 

3 Tom           ...        1.5

4. Dick          ...        0.9

5 Harry.        ...        2.2

5 Sam           ...        4.0


1 Reply
if you have a newer version of excel (I think 2019+) then you can use XLOOKUP:
=XLOOKUP(J2,J3:J100, B3:B100)
In older version you would need to use INDEX(MATCH()):