|You haven't provided a lot of detail so we can't be very specific, but one possible method is to use Data Validation Drop Down lists and VLOOKUPs.|
You could have a Drop Down list for your products or "product dcodes" (whatever those are) and then use VLOOKUP functions to pull in the prices if that's what you need.
There are lots of templates to get you started. Once you download something you like, you can add formulas and drop downs to customize it. Start here:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.