I am trying to automatically populate cells based on the selection made in a drop down field.
The workbook is structured so that sheet 1 has a drop down box, and sheet 2 has the fields for that box, along with fields which correspond to the selection.

I am trying to pull data in the same row as the data selected by the drop down into specific cells in the first sheet.

Which formula should I use?

I have investigated both an Index and Vlookup, without success.

I have attached a Workbook which demonstrates what I am trying to do Demo Book.xlsx