Make a drop down selection change other cells

Hello All,

I am trying to figure out how to make a drop down menu change the 3 following cells in the row once a selection has been made. If you refer to the attached image you can see that I have "Product 1" with 3 different prices. I want those 3 prices to show next to the drop down when "Product 1" is selected and so own for the other 2 products. I know basic excel and have several Excel manuals. It would be greatly appreciated if you could guide me through this but if not please point me in the right direction.

Excel forum pic.png

Thank you so much. Thank totally worked!