LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup 1st column time 2nd column text Kathl Excel Worksheet Functions 12 August 12th 08 05:30 AM
VLOOKUP question utilizing the right and left of a given column ineed the mid too dont know how to incorporate. TIA for help EP Excel Worksheet Functions 1 May 31st 07 04:11 AM
vlookup- is a must that lookup value should be the leftmost colum? hettie Excel Discussion (Misc queries) 3 September 20th 06 04:30 AM
VLOOKUP question...it probably can't... roger_home Excel Discussion (Misc queries) 2 February 15th 06 11:57 PM
VLOOKUP question Tom Weston Excel Discussion (Misc queries) 2 February 10th 06 06:44 PM


All times are GMT +1. The time now is 12:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"