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