There is a range given on one column and on the other column there are points. Ex:
200 - 180. 10 points
179 - 160. 9.5 points
159 - 130. 8 points
How I put a formula in excel when I write 168 it should reflect 9.5 points in front of that. And if I change the value to 141 it should reflect 8 points. I have a long range starting from 0.
Could you please assist me?