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