lookup the date beside a cell that matches a value
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
|