vlookup and 2 max values

**geebee** · 10-10-2007, 02:50 AM

Hey,

I want to find a max value in a column 1 and return a corresponding value in column 2, for this I use VLOOKUP.
The problem - if there are two same values in A1:A20 (e.g, two times number 2),
it gives a random value of column 2 .In case there are two same values in column 1, I would like to get "NA" or smth instead of that,
how is that possible?

thanks a lot!!

**VBA Noob** · 10-10-2007, 04:45 AM

See if link helps

http://www.cpearson.com/excel/Rank.aspx

VBA Noob

**geebee** · 10-10-2007, 01:42 PM

Originally Posted by VBA Noob

See if link helps

http://www.cpearson.com/excel/Rank.aspx

VBA Noob

thanks, very useful, and similar to what I need, but still, couldn't get the answer from this link.

My problem is :

a list of players and their score

score
Name primary secondary ... etc

Tom 9 8 7
Bob 8 6 5
Gill 8 5 4
Ruth 4 6 3

So, in my case, the score is ranked.
I need to pick the winner first by finding max of the first column. IF there are two same scores, THEN look at the "secondary" score column and CHOOSE that one person from the two, who scored more. IF they again get the same, then refer to the third column ... etc etc.

Does anyone have any idea how to model this situation?

I'd be really greatful for your help!

**VBA Noob** · 10-10-2007, 01:45 PM

Sounds like

Double Ranking And Tie Breaking

at bottom of link.

Did you download the example

VBA Noob

Thread: vlookup and 2 max values

Thread Tools

Display

vlookup and 2 max values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions