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

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
 
D

Dave Peterson

How about:

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

Adjust the ranges to match your data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search for Max Value in one column & extract the corresponding data in next cell 4
Column header for Max value? Index/array function? 5
Conditional formatting based on max in range of other columns 2
Max Value - based on a time period 3
Making MAX and MIN range variable 1
Vlookup for a max value ? 4
MAX only Rows in Range where another Row is Not Blank 3
Count cells w/values in column if the data in column a matches cri 3

Top