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?