I have the following
lower upper
1 30
0.5 20 30
0 10 20
-0.5 0 10
-1 0
Now, I have:
Mike 12
Tim 35
Fred -5
Paul 8
Joe 28
I want to create a column C where a formula looks up the range puts in the correct number.
Mike 12 0
Tim 35 1
Fred -5 -1
Paul 8 -0.5
Joe 28 0.5
How to do this?
I have created a sample sheet
https://docs.google.com/spreadsheets/d/1wOHSuZW4tLnjf7peo_lTufxJGJkr4KKS2Q0RmuoqLrA/edit#gid=0