I need help with either a vlookup/hlookup or index/match formula.
I have a table of values with the column headings as dates.
In the column after the last value I need to insert the date of the column associated with the maximum value in that row.
Example:
Row 11 has dates in each column from J to U
Row 30 has values (unsorted) in columns J to U
I wish to insert (using a formula) in cell V30, the date from row 11 that corresponds to the MAXIMUM value in row 30 from columns J to U.
So, if S30 was the maximum value the I wish to display the date from S11.
Any ideas on how to do that?
Bookmarks