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?
 
Thanks Frank
I appreciate your help
Thrava
-----Original Message-----
Hi
try
=VLOOKUP(D1,A1:C100,3,1)

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
You must log in or register to reply here.

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 formula 5
Lookup or VLookup or something else?? 2
what is the formula for what I want to do 1
Help with formula 1

Back
Top