Max (A1:A1), relating to other cells

[Mark Solesbury]

Ive got Max A:A, which returns the maximum number in column A. How can i
get another cell to show the data from column B, which is pulled from
the same row as the result of Max A:A.




--
Mark


http://www.mozilla.com/firefox/ - Firefox Rules!
http://fireftp.mozdev.org/ - FTP Plugin for Firefox
http://ietab.mozdev.org/ - IE tab. Get Windows updates in Firefox

 

[Guest]

Try something like this:

=INDEX(B:B,MATCH(MAX(A:A),A:A,0))

Note: if there are duplicate MAX values, the formula returns the information
for the first MAX match in the list.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

 

[Pete_UK]

Try this:

=VLOOKUP(MAX(A:A),A:B,2,0)

If you have two or more values that are equal to the maximum, this
will bring data from the first match found.

Hope this helps.

Pete