How to detect threshold within a cell range [closed]

edit

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