It is going to be something like

=INDEX(AM19:AS28,MATCH(B13,AM19:AS19,1),MATCH(B19, AM20:AS20,1))

but the data layed out would help clarify it fully.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ben" wrote in message
...
I recently posted up a question as to which type of formula I should use to
achieve what I want the workbook to do.

The workbook actually creates a quote based around the sale of USB
products.
Basically, when I have selected what size (capacity) that I want to quote,
I
then type in the quantity. From here, the formula then needs to look up
what
capacity I am offering in the capacity cell and then the quantity in the
quantity cell before looking to a cell range which shows quantity breaks
(ie.
1 column for 100pcs, 2nd column is 250pcs) and then the price is then
calculated.

So, for example, if I select a 128MB device, and the customer wants
200pcs,
it should look up within the cell range and see that 200 comes between the
column of 100pcs and 250pcs and offer what is in the 100pc column.

Currently, the formula that is in the cell is as follows:
=INDEX(AM19:AS19,MATCH(B13,AM20:AS28,0),MATCH(AM19 :AS28,0))

A guide to the cells a

AM19:AS19 = Quantity Break Column Heads
B13 = Capacity Cell
AM20:AS28 = Various prices depending on the columns
B19 = Quantity Cell

For some reason the formula will not work and I have beta'd numerous ways
to
try and solve it but cannot.

Can anyone submit any suggestions as to how I can solve this ??

Many Thanks,
Ben