Hi,
I want to report the value in column F corresponding to the first value higher than 10 in column I and corresponding to A1 in column A. To extract the first value, I was able to use this formula :
=INDEX(G:G,MATCH(INDEX($I3:I206000,SUMPRODUCT(MATCH(1,--(I3:$I206000>10),0)),1),I:I,0),1)
But, then I want to do the same for the value A2 from column A, for A3... and so on.
I have created Sheet2 as a reference.
Thanks in advance for your help.
Simon
Bookmarks