Information Auto-Fill

TMShucks beat me to it. learn the VLOOKUP function. Microsfot has a lot of info about it, search VLOOKUP.

I did make an example using your original spreadsheet.
This allows you to enter an item and return the price.
Copy down the vlookups for as many items as you want to return information for.
I also entered in a Quantity total, to show how you can use the returned information and calculate total prices.

Enjoy the chocolate covered Storks!