sorry if i was unclear i am trying to prepare a spreadsheet where users
can prepare ther own qutes so if they enter the quantity and number of
colours the spreadsheet will do the rest
so the 250 selects the row with those values and if they enter 3
colours then the formula should select the correct value €1.56 from the
table above. i think i need to use index and match functions but just
not sure the format


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