To better understand what I'm saying I made a screen shot of the excel spreadsheet I have made. - http://img202.imageshack.us/img202/4237/picforhelp.png - The formulas in this screen shot aren't updated.

Ok i have an item database and I wanted to have a drop down menu under the description column where I can select the item and it automatically fills in a code to the product in the column to the left of it and the unit price 2 columns to the right. Right now I have formulas in the code column and a formula in the unit cost column and the only problem I have with this is if I want to manually type the price in for a product the formula is deleted and if this form drags on for days its not going to be easy to get the formula back. So if you if this is possible let me know. If I wasn't detailed enough with my description and not seeing the screen shot please ask for more information.
-Thanks a lot David W.