Try this in a cell formatted the same as your ColumnA:

=INDEX(A52:A151,MATCH(MAX(B52:B151),B52:B151,0))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Gwen Frishkoff" wrote in
message ...

Hello. I think this is a simple question, but the match, lookup, and
index functions that I've tried haven't worked. I have some experience
with XL, but I am not an expert user.

Let's say I have two columns, colA and colB. ColA is a list of time
markers; colB is a list of numerical values (measurements at each
timepoint). I want to:

1. find the max value in colB (between B52:B151).
2. find the timepoint that corresponds to the max value computed in 1.

The result that I want is the value computed in 2.
Any assistance would be greatly appreciated.

Gwen


--
Gwen Frishkoff
------------------------------------------------------------------------
Gwen Frishkoff's Profile:
http://www.excelforum.com/member.php...o&userid=15907
View this thread: http://www.excelforum.com/showthread...hreadid=273889