Auto complete?

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.