Drop down list = price when product selected

Hi,

I would like to know if someone can help we with this.

I have a spreadsheet with a sheet that has a list of products in one column and the price on the other column. I want to create another sheet in the same spreadsheet that i will insert a drop down list (which will be the list of products on the other sheet) and when you select a product, it picks up the price on the column next to the product.

So to recap, i have a product list and prices. I want to pick a product from a dropdown menu and it will automatically pickup the pricing from the list.

Let me know how to achieve this because i have hundreds of products.

I've attached a document to explain what i'm trying to do.

thank you,