Look up function and Max function

[karim]

I have
21 columns A to U, and 600 rows.

I want use look up function for the maximum to return the value from the
first column (A) from the same position in each column without ordering each
one . Do you know a quick easy way to do it?

Means I want to get the maximum value in each column and match it with the
corresponding cell (same row but from Column A).

Best

 

[KL]

Hi,

Try this:

=INDEX($A$1:$A$100,MATCH(MAX(B$1:B$100),B$1:B$100,0))

Regards,
KL

 

[Duke Carey]

Maybe:

=index($A1:$A600,match(max(b1:b600),b1:b600,0))

copy it across for all the columns to U