help with lookup or something else

T

Thrava

I want to write a formula, say in cell E2 that picks the
correct price based on valume Entered in Cell D1.

Suppose I have a table set up with volume vs price. sush
as:

Column A B C D E
Row 1 From TO PRICE Volume Entered ??
Row 2 500 600 $1.20
Row 3 601 700 $0.99

Etc... down the row. I know I can use vlookup ordinarily
but now there are two columns. If volumn is between 500
to 600 then the price is one thing, if volumn is between a
different braket is something else.........
What is the best formula to use for this?
 
Top