Corresponding value from MAX function

[stevstev]

Hello,

I was wondering if someone could help me on this problem. I have two columns of values:
1400 1.75
1600 1.77
1800 1.78
2000 1.78
2200 1.78
2400 1.76
2600 1.72
2800 1.59
3000 1.39
3200 1.22

and I want to find the value in the left-hand column corresponding to the maximum value on the right-hand column. And I want to have the largest value on the left-hand column if there are > 1 max values on the right-hand column. So, for example, in this case, I want to return 2200, corresponding to the last 1.78 value. The only method I've found is to do: "=INDEX(B1:B1000,MATCH(MAX(A1:A1000),A1:A1000,0),1)", which will only return the value associated with the first occurrence of the max value (i.e. 1800 in this case).
Thanks for any help

[BigBas]

Assuming your range is A1:B10, use an array formula like the one below:

=MAX(IF(B1:B10=MAX(B1:B10),A1:A10))

Note: This is an array formula. You must press CTRL+SHIFT+ENTER to confirm

Let me know if it works

[stevstev]

Thanks for the quick reply. It works!