I am trying to use the lookup function to display the price of a widget with
a given volume that I will use as an input cell. The issue the volume is a
range using two cells. See below


Volume Price
- 10,000 3.00
10,000 - 50,000 2.00
50,001 - 100,000 1.00

How do I setup a lookup formula to accomplish this? Keep in mind the ranges
of volume per price are in two separate cells. So 0 and 10,000 have their
own cell.