Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default =Lookup()

Not sure what is happening here. Here is the data:

ColA ColB
Service 17
Variety 1
Relations 14
Experience 20
Knowledge 10
Value 8
Reputation 3

Created 3 formulas to retreive the 1st, 2nd, and 3rd highest numbers in the list (e.g.: Cell C1 has formula =Large(B1:B7,1), Cell C2 has =Large(B1:B7,2), etc.)
Then I want to return the text value from column A and use:
=Lookup(C1,B1:B7,A1:A7)
This works for the first value and returns Experience
The second one returns Relations (wrong answer - should be Service)
The third one returns Relations (wright answer). . .

Any ideas?
 
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



All times are GMT +1. The time now is 10:40 AM.

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

About Us

"It's about Microsoft Excel"