# [SOLVED]Finding matching value [closed]

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

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by m.a.riosv close date 2019-01-24 00:39:15.294596

EDIT: I figured out my mistake. =INDEX($B$3:$B$17;MATCH(H11;$E$3:$E$17;0)) fixed it