help with lookup or something else

  • Thread starter Thread starter Thrava
  • Start date Start date
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula finding price based on volume bracket 7
VLOOKUP / Auto Fill / IF? 4
Formula help (Lookup) 6
Sort with IF functions? 5
Lookup or VLookup or something else?? 2
lookup formula 5
what is the formula for what I want to do 1
Help with formula 1

Back
Top