Hi Bob,

Thanks for that - I tried replicating this but just need to know which cells
reflect what in the formula you did so I know which ones to adjust in the
actual workbook itself.

Thanks,
Ben

"Bob Phillips" wrote:

This worked for me

=INDEX(A1:H20,MATCH(L1,A1:A20,0),MATCH(M1,A1:H1,1) )

you will need to adjust the cells


--
---
HTH

Bob


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



"Ben" wrote in message
...
OK. Basically, once I've selected the capacity and entered in the
required
quantity, the cell should look to this cell range - here I have copied the
first 2 rows / columns:

100 250 500 1000 1500 2500 5000
32MB £0.01 £0.02 £0.03 £0.04 £0.05 £0.06 £0.07

So, basically, based on the capacity selected (32mb) and the quantity
entered (which maybe exactly those in the row headings, or in between), it
should display what is in the the corresponding cell underneath (so for
100pcs, 0.01 or for 275pcs, 0.02 as its based on the 250pc price)

Hopefully this helps and you can advise me some suggestions !

Many Thanks,
Ben



"Bob Phillips" wrote:

I mean to present a sample of the data in a message, cells addresses and
values, and tell us what the expected result should be.

--
---
HTH

Bob


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



"Ben" wrote in message
...
Hi Bob,

Thanks for that.
What do you mean by the data being layed out therefore clarifying it ??

I have put that formula in, selected a capacity and then typed in a
quantity
but it still comes up with #N/A

Thanks,
Ben

"Bob Phillips" wrote:

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