How to detect threshold within a cell range

[moi1]

Hi!

I’d like to detect where a value reaches a threshold within a range of cells. When the threshold is reached, I want to read a cell above.
My table contains a %age that grows up to 100%. I’d like to find when it reaches 70% and read the cell just above the >70% value.

Couldn’t find any smart function to do this…

Thanks!
Laurent

[karolus]

Hallo

=INDEX( A1:A999 ; MATCH( 0.7 ; A1:A99 ;0 )-1)

in case the entries are in ascending order, use:

=INDEX( A1:A999 ; MATCH( 0.7 ; A1:A99 )-1)

[moi1]

Excellent, thanks!