Maybe:

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

copy it across for all the columns to U

"karim" wrote:

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