Thank you "Gary's Student," but it didn't work. I think that the
instructions for VLOOKUP have buried in them the admonition that the data
column you are searching has to be sorted in either ascending or descending
order. That is not true of a data column with a max value buried in the
middle of it somewhere. Of course, it would be possible just to do a brute
force sort of the two columns of data, but it seems that would be an
unnecessary and time-consuming operation. You would then have to manually
transcribe the value you discovered. Thanks anyway. TECHNOID

"Gary''s Student" wrote:

FIrst thing is to reverse your columns, so that speed in in column A. As you
point out you can get the max speed with the MAX() function. Then you can
use VLOOKUP() to find the associated time. If speed is now in A1:A100 and
time is now in B1:B100 then use:

=VLOOKUP(MAX(A1:A100),A1:B100,2)
--
Gary's Student


"TECHNOID" wrote:

Suppose I have two columns of data. Column A is the independent variable,
say TIME. Column B is the dependent variable, say SPEED. The data are
collected on a car that starts from rest, accelerates, decellerates, then
stops. Clearly, the car attained some maximum speed during the test. I can
find the value of the maximum speed by using the worksheet function =MAX(B),
but I want to know at what time (column A) the maximum occurred. Of course I
can do a manual (visual) search, but this is laborious and eye-straining for
reams of data. What single worksheet function (or more likely, nested
functions) can I use to return the time value?