How to detect threshold within a cell range


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…



=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)

Excellent, thanks!