Home |
Search |
Today's Posts |
#1
|
|||
|
|||
=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? |