Kevin,

I'm afraid I don't understand. Perhaps I need to explain a bit further:

I am trying to create a pricing calculator for delivery of freight to
various different countries. Each country's pricing is on a seperate tabbed
sheet.

I have created a 'front sheet' where I want the client to be able to put the
most basic of information, # kilos against a country, and in the cell where
it says total freight cost, I want to insert a calculation where by it
multiplies the number of kilos by the correct tariff on a different tabbed
sheet, returning a value on my front sheet. I can't seem to get the Lookup
to work with gathering information from tabbed sheets.

"Kevin B" wrote:

A VLOOKUP function would serve you well. The table would look like the
following example, let's say A1:B5:
A B
1 $1000
101 $950
151 $900
201 $850
251 $800

If the value of 212 is in A20 and the formula for unit price is in B20 the
VLOOKUP would look like this:

=VLOOKUP(A20,$A$1:$B$5,2)

Where A20 is the value to locate in the table, $A$1:$B$5 is the actual
location of the table and 2 is the column in the table that contains the
result value.

Hope this helps...
--
Kevin Backmann


"Jamie" wrote:

Hello, My question is almost exactly the same as Pauline - rockstars on,
6/27/2007, it concerns price breaks, i.e $100 for orders of 1 - 100, $90 for
orders of 101 - 200 etc etc, however, I have 12 volume price breaks, and
apparently can't use more than 7 'if' commands, can anyone think of a way?


EG. 1-100 units = $1000 per unit
101 - 150 = $950 per unit
151 - 200 = $900 per unit
201 - 250 = $850 per unit

I have 12 breaks!!

Please help

Thanks
Jamie