This should get you started...using simple vlookups, referencing a table
of all product codes and associated info, you can do this fairly
simply.
I used the if(isblank()) formulas to keep the page clear if nothing is
selected.
Let me know if you need more help.
+-------------------------------------------------------------------+
|Filename: For_ MNicholas.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3704 |
+-------------------------------------------------------------------+
--
Excel_Geek
------------------------------------------------------------------------
Excel_Geek's Profile:
http://www.excelforum.com/member.php...o&userid=26423
View this thread:
http://www.excelforum.com/showthread...hreadid=396989