To return the player name that corresponds to the high sco

=INDEX(name_range,MATCH(MAX(score_range),score_ran ge,0))

If you want the top n:

=INDEX(name_range,MATCH(LARGE(score_range,ROWS(A$1 :A1)),score_range,0))

Copy down as needed.

However, (seems there's always a however !!!) this will not work properly if
there are duplicate high scores that fall within the top n.

--
Biff
Microsoft Excel MVP


"mpenkala" wrote in message
...
Hi there,

I have a table full of stats for a basketball team. It's laid out
something
like so:
Player Name - Posistion - Pts/Game - Rebounds/Game - Asst/Game - High
Score

Lower down on the same page I have a spot for the High games of the year.
I've used the LARGE function to find out the top 3 scores. Now I'm trying
to
use VLOOKUP to match the score given by LARGE,1 and give the name of the
player who scored it.

I've used VLOOKUPS before but is it possible to lookup a number in the
table
that isn't the leftmost column?

Thanks,
Matt