creating a quote spreadsheet

[andyell]

I am trying to create a quote system using excel, and need to be able to select from
a range of quantities and then
select from a range of colours

I have tried using index and match functions but this will only work if the quantites are the same as in the table.but i need to be able to select from a range of quantities
0-15
16-24 etc

I cant use nested if statements as there are 12 quantity groups

thanks in advance

[Max]

See a response to your multi-post in .worksheet.functions
(Please do not multi-post)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[andyell]

Max, I cant log in to download these files?

Andy

PS Sorry for the multi post

[Max]

"andyell" wrote:
> Max, I can't log in to download these files?

Try it again, Andy.
I've just re-uploaded into the same link, and tested the link ok.
Sample construct at:
http://www.savefile.com/files/5747910
Quote System 2 variables Tiered Qty by Colour.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[Max]

Here's an alternative link to the sample (just in case):
http://cjoint.com/?gnqbexXB3B
Quote System 2 variables Tiered Qty by Colour.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[Max]

Here's an alternative link to the sample (just in case):
http://cjoint.com/?gnqbexXB3B
Quote System 2 variables Tiered Qty by Colour.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[Max]

Here's an alternative link to the sample (just in case):
http://cjoint.com/?gnqbexXB3B
Quote System 2 variables Tiered Qty by Colour.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---