creating a quote spreadsheet

[andyell]

I am trying to create a quote system using excel, and need to be able t
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 i
the quantites are the same as in the table.but i need to be able t
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 advanc

 

[Max]

See a response to your multi-post in .worksheet.functions
(Please do not multi-post)

 

[andyell]

Max, I cant log in to download these files?

Andy

PS Sorry for the multi pos

 

[Max]

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]

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