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 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?
Solved by V. Q. in 16 mins