Hi folks, please see attached spreadsheet. I need to have excel look for a minimum and maximum value in a cell (column) range, and then report the corresponding date that is associated with that cell. I think I probably need to use lookup, match, index, or a combination of these values in my formula. Any suggestions. Thanks

Attached Files

FOR EXCEL FORUM.xlsx (8.7 KB, 10 views)

=index($a$4:$a$7,match($e1,$b$4:$b$7,0))
=index($a$4:$a$7,match($e2,$b$4:$b$7,0))

Yes, that works perfectly, I knew it was those functions or a combination of them. Thanks for the quick reply!