How to auto fill a cell on new sheet when selecting item from drop down list?

Hi to all,

I'm new to this site, but have heard some great things about the members. Thought I'd give it a shot.

I'll try to explain my situation as simply as possible.

Sheet 1: Drop Down List
Sheet 2: One column (C5:C16) for drop down list and another column next to it (D5:D16) with prices for items listed in first column.

I've created a drop down list in cell F10 in sheet 1 with data (Sheet2!C5:C16) from sheet 2.

I want the cell F11 to automatically fill itself with the data from (Sheet2!D5:D16) when an item from the Drop Down list is selected.

Example when looking at Sheet 1:

If I choose ITEM 8 (Sheet2!C8) from the drop down list, I would want (Sheet2!D8) to appear in cell F11.
If I choose ITEM 15 (Sheet2!C15) from the drop down list, I would want (Sheet2!D15) to appear in cell F11.
Etc

I hope my scenario is clear enough. Let me know if you need additional detail.

Thank you

Mat.

Can you possible post a sample workbook with expected resultsas it is much easier to work with data.

Click "Go Advanced" and then the "Paper Clip" icon ==> Add File==> Browse==>Load==>Done

Thank you.

Here it is.

Thank you

See attached

Thank you very much @JohnTopley. Greatly appreciated