Still haven't developed the spreadsheet with the formula but ive written
down in theory...the drop down list i suppose will have three items,
mars, coke and fanta

It's basically what i stated above..

Thanks for your time

From John Wood


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=501876