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,

This can be done through an Index match statement (I did something similar recently), however how to write it has currently escaped me.

This, will also work

=INDEX(Products!$A$2:$B$5, MATCH(order!$A$2,Products!$A$2:$A$5,0),2)

In B2 on the order tab

Indeed! Was just taught to include the entire array within the index