Thread: excel function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
asburypark98[_2_] asburypark98[_2_] is offline
external usenet poster
 
Posts: 12
Default excel function

Hi all,
my problem is as follow.

Column A
alfa
beta
gamma
theta
epsilon
ro

Column B
0.00000%
6.57481%
153.23505%
-2.51575%
0.00000%
153.23505%

Column C (in other words, the same value
of Column B, but sorted)
153.23505%
153.23505%
6.57481%
0.00000%
0.00000%
0.00000%

Column D.
I'd want to get the values (in column A) for every values
in Column C, so I used:
=INDEX($A$3:B$337,MATCH(C3,$B$3:B$337,0),1)
but the result is not the one right.

I get:

gamma
gamma
beta
alfa
alfa
alfa


For example: the value 0.00000%, I always get "alfa" : but in the
first
case "alfa" is right, in the second case I'd like to get "epsilon".
The other case: the value 153.23505%. In the first case, I get "gamma"
and it's right, but in the second case I'd like to get "ro", instead
of
"gamma" ..

What should I do to get, for every value of Column C, the right value
of Column A ?

Any suggestion very appreciated.