Sorry, that response got messed.

Try this formula

=INDEX(1:1,,MATCH(MAX(2:2),2:2,0))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steven Sinclair" wrote in
message ...
If I have two rows of numbers...

5 10 15 20 25 30 35 40 45 50
1 16 23 18 64 28 46 72 18 26

Is there a formula I can insert, in another cell elsewhere on the sheet,
that will find the largest value in the second row, but return the
corresponding number from the first row? In the above example, I could use
"=max(b1:b10)" to find the largest number in row b, but how do I reference
row a?

Thanx.