[SOLVED]Finding matching value [closed]

asked 2019-01-23 09:49:11 +0100

Laniakea gravatar image

updated 2020-09-03 13:26:50 +0100

Alex Kemp gravatar image


I have trouble figuring out how to get the corresponding value for cell H11 to appear in cell I11 Example

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 flag offensive 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

Laniakea gravatar imageLaniakea ( 2019-01-23 11:01:32 +0100 )edit