Hello!
I have trouble figuring out how to get the corresponding value for cell H11 to appear in cell I11
I want to automatically (i. e. that if column is extended, the new year for the new MAX value is inserted in I11)
insert the year in which the MIN/MAX value for a column is reached in cell I11.
What I mean is that in this example the max value for column E is in E3, now I want the matching year 2005 to appear in cell I11.
I (unsuccessfully) tried something like INDEX(B3:B17;MATCH(E3:E17;H11;0)) for I11.
Any ideas/help to fix my problem is appreciated!
~ Laniakea