|re: "Where can I find out about Lookup Statement."|
You can find out a lot about using VLOOKUP in both the Excel Help files right on your machine or via a Google search.
Once you have familiarized yourself with the function, come on back if you need help with your specific task.
Once you get comfortable with VLOOKUP, you might want to go the next step and consider Dependent Drop Down lists.
With Dependent Drop Down lists you could create a list of manufacturers in a Drop Down. Once a manufacturer was chosen, a second Drop Down would automatically populate with the models specific to that manufacturer. Once a model was chosen, the price could be retrieved via VLOOKUP.
With Dependent Drop Downs, keeping the manufacturer/model number lists can be a little easier since you would have smaller groupings instead of one long drop down list with every manufacturer and model in your inventory. When models and/or prices change, you would change the values in the range specific to that manufacturer.
See here for instructions on using Dependent Drop Down Lists:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.