I am using drop down selections as an order sheet that searches the document to gather pricing from tables throughout various tabs. In the "order Generator" tab under the "Homeowner delivery" section i want it to show the estimated delivery duration when the price is generated.All the cells outlined in bright red in tabs "order Generator and Topsoil is what you need to refer to. i tried to color code these cells to help explain how it works.
Solved by S. F. in 30 mins