Search for Max Value in one column & extract the corresponding data in next cell

  • Thread starter Thread starter Meng
  • Start date Start date
M

Meng

Hi,

I need to search for the Maximum number in column B and
then extract the corresponding data in column A.

For Eg see table below, in this case the Max in column B
is located at cell B4, and I need the excel to output the
corresponding data at cell A4 which is 14.

Could anyone help to provide a formula for this?

A B

1 10 6
2 11 7
3 12 8
4 14 10
5 15 9

Regards
 
Hi,

I need to search for the Maximum number in column B and
then extract the corresponding data in column A.

For Eg see table below, in this case the Max in column B
is located at cell B4, and I need the excel to output the
corresponding data at cell A4 which is 14.

Could anyone help to provide a formula for this?

A B

1 10 6
2 11 7
3 12 8
4 14 10
5 15 9

Regards
Click to expand...


=INDEX(A1:A5,MATCH(MAX(B1:B5),B1:B5,FALSE))


--ron
 
Back
Top