Try this:

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


--
Biff
Microsoft Excel MVP


"chris miller" <chris wrote in message
...
I have a column A with dates and column B with data. I'm trying to create a
summary sheet. I use the max function on column B, which is easy, but I am
also trying to place the corresponding date (to the max value) on the
summary
sheet as well. I've tried using the lookup function but it seems to return
the last value in the date row? Any help would be greatly appreciated