Creating a Pre-filled list

I am hoping to create an excel sheet to help the sales department calculate discounts for their customer easily. I created a basic table with our products and I would like to be able to select a clie...