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.

excel function
 

Be sure that your data starts in row 3, or change your formula to reflect the
actual row that the data range begins in.

=INDEX($A$3:$B$337,MATCH(C3,$B$3:B$337,0),1)


"asburypark98" wrote:

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.

excel function
 

On 21 Giu, 16:13, JLGWhiz wrote:
Be sure that your data starts in row 3, or change your formula to reflect the
actual row that the data range begins in.

=INDEX($A$3:$B$337,MATCH(C3,$B$3:B$337,0),1)




the formula is right. my data start in row 3 end ends in row 337..