I have a graph which is a bell sort of shape. I want to find a corresponding x value on the right side of the curve, but when i use lookup obviously it just finds the first value which the y value is at that x value. How can I make it always choose an x value which is say above the halfway point of the x values.
Solved by D. H. in 22 mins