Formula to change based on selection in another column

I’m creating an order form in Excel to be used by clients. The idea is that the client will select a product from a dropdown list in the first column of the table (tbl_Product_Order) and then in the...