Studio Rental Spreadsheet.xlsmstudiolist.xlsxOkay. Excel Novice, here, so please be patient with me.
I am attempting to put together a new studio reservation template for the company I work for. It is you basic reservation form, but all of the data that I need to use in all the drop down boxes are from another workbook so we can update the information with one simple step.
Now, I have two drop down boxes, one for the studio number and another for which type of renter (non-profit, student or commercial). Based on what you select from those two drop-downs, I would like the correct price point to pop up in the adjacent cell. Because all of my data is on another worksheet, I am having some major trouble finding any sort of instruction online. I have tried several formulas on my own, and none have worked. Now I am just frustrated and ready for some help.
I have uploaded both the reservation form and the separate workbook with all the data.
Any assistance would be very very appreciated. Thank you.
Bookmarks