How to search Max value in 1 column & output the corresponding data in next col

  • Thread starter Thread starter Wee Meng
  • Start date Start date
W

Wee 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
 
How about:

=INDEX(A1:A20,MATCH(MAX(B1:B20),B1:B20,0))

Adjust the ranges to match your data.
 
Back
Top