I've created a table (not using the table tool just using the cells) in Excel in one sheet.
In another sheet I have called the min/max function for that table to return the highest/lowest value.
However I also want to know what year that value corresponds to so I was wondering how this can be done?
B38:B55 are the years and
E38:E55 are the values that are being searched.
How can I retrieve the corresponding year value?