Noob question..please help

[siamsunset]

Hey everyone,

Im running an export/import company and am looking to make an invoice spreadsheet to list products and prices. Im trying to simplify the process and am looking at having 4 fields. Product code/Description/QTY/Cost. My goal is to have it so all i have to do is enter the product code and it fills in the description/cost fields automatically. Im guessing im going to have to use a database and pull the information from there. Thing is i havent used excel for 10 years and have no idea where to start.
Please help...

 

[SteveO59L]

In any four columns list out your product code/description/qty/cost data.

Use Data, Validation, Allow, List and define your list as the product code.
This produces a drop down list with your product code, for the rest of the data use a vlookup function to look up the values based on the product code selected.


HTH