I have something that seems simple, but I can't seem to figure it out.

I have a list on Sheet 1. In column A it contains model numbers and descriptions. In column B it contains prices for the adjacent A column cell. I want to create a pull down list on a new sheet, or even on a nearby location on the same sheet so that I can select a model#, have it appear in the pull down column, and have the product's price appear in the adjacent column.

So, for example, in a pull down menu in cell D1, I select Sprocket 22 from A1. I want the pull down cell to show Sprocket 22, and cell D2 to show the price in cell B1. Once selected I can have formulas referencing the price in the D2 cell filled in by the pull down list. Can't find an easy way to do it, and ActiveX controls are a bit beyond my expertise.

I use Excel from Office Pro 2016. Thanks for your help!