creating a quote spreadsheet
 

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


--
andyell
------------------------------------------------------------------------
andyell's Profile: http://www.excelforum.com/member.php...o&userid=35272
View this thread: http://www.excelforum.com/showthread...hreadid=550821

creating a quote spreadsheet
 

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

creating a quote spreadsheet
 

Max, I cant log in to download these files?

Andy

PS Sorry for the multi post


--
andyell
------------------------------------------------------------------------
andyell's Profile: http://www.excelforum.com/member.php...o&userid=35272
View this thread: http://www.excelforum.com/showthread...hreadid=550821

creating a quote spreadsheet
 

"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
---

creating a quote spreadsheet
 

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
---