Find Ranking

[Rod]

Hello,

I have A10 to B19:
988,596 1
874,126 2
805,272 3
753,053 4
743,739 5
734,685 6
665,335 7
643,460 8
640,664 9
633,636 10

If the number 743,740 is calcualated in another cell, say D10, I would like
to return 5 because 743,740 is the 5th ranked number.

Thanks.

 

[Niek Otten]

<743,740 is the 5th ranked number>

I don't think so. It's the 4th.

What makes you think it is 5th?

If I'm right, this is the formula:

=INDEX(B10:B19,MATCH(D1,A10:A19,-1))

 

[Per Jessen]

Hi

Try this:

=VLOOKUP(D10,A10:B19,2)

Regards,
Per