Thanks for all the help. In the end i did create a third column which
was a combination of whichever items were chosen. So, if apples and
supplier Bob were selected, the new column would give apples.bob. I
then used this new list to create the pull down.

=C45&"-"&D45 (C45 having products and D45 Suppliers)

If anyones confused i can explain more... but right now i'm in a rush.

Again, thanks for all the help,

Chris


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=499022