Return Text In Cell realting to Max Value in different colum

[samprince]

I am unsure how to write this formula.

In Column 0 - I have the Weekly Totals.
In COlumn F - I have the Week Beginning Date.



The max/min weekly totals change as time goes on.

How can I return the Date the Max/Min Occured in a separate sheet i
the same workbook?

Tyv

 

[starguy]

put a sample of your data.

 

[Dave Peterson]

=index(sheet1!f:f,match(min(sheet1!o),sheet1!o,0))
=index(sheet1!f:f,match(max(sheet1!o),sheet1!o,0))