autofill - dropdown menus

[luxtexas]

I'm trying to create a basic temporary invoice system until my software arrives with what I need.

In column A I have created a drop down menu of baked goods. I need column B to have an auto-fill of pricing based on what I choose from column A.

Any suggestions? Would this be a macro or micro? If so how would I go about creating such?

 

[shg]

Just a lookup formula to retrieve the price from another list. See Help for VLOOKUP.