I have the following table

A B C
1 From To Amount
2 0 10 10
3 11 20 30
4 21 50 40

I would like to enter a value in D1 Cell -- 34
What is the formula that is going to return 40 because 34 is in between 21
and 50?

Thanks so much