Can this be done in Excel? : I want a list of products and their prices like so:

             D       E
          ---------------
      1   product | price
          ---------------
      2    hat    | 2.00
          ---------------

I'd like this list (and other like it) to be in their own tabs. I want my main tab to be able to pull the product name from a drop down list in one cell but auto-populate the price in another cell like this:

    1 | hat | 2.00 (this is automatically populated when I choose hat)

I would also like more properties of the hat populated besides just price. I realize this is probably more for something like Access but I'd really like to do it in Excel. 

