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


"Mark Solesbury" wrote:

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