I need the ability for a user to select an Order No. from a drop-down menu inMS Exceland then automatically display some of the corresponding info. Specifically, you'd be able to select the Order No. from a drop-down in the first cell you create, then the second cell would give the Item Description, the third cell would give the Supplier name, the fourth cell would give the Discount Price, and the last cell would show how many days elapsed between the Order Date and Arrival Date. The Discount Price would include a 5% discount on the "Cost per order" for August orders and a 10% discount for September and October orders. We're not authorized to give discounts yet for November orders.

Attaching the sample data for reference