I have one I can't figure out in Excel. I have values 1-10 listed in A1-A10 then a list of non-linear numbers in cells B1-B10. I want to compare an input value in B11 to B1-B10 and calculate the fractional value from cells A1-A10. For example:
A value of 875 should return a value of 3.16. Is there a function to look at the table and do this?
1 | 500 |
2 | 700 |
3 | 850 |
4 | 1000 |
5 | 1500 |
Input -> | 875 |
A value of 875 should return a value of 3.16. Is there a function to look at the table and do this?