View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mpenkala mpenkala is offline
external usenet poster
 
Posts: 90
Default Vlookup Question - Reffering to a column other than the leftmost?

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