# Completely Lost --Dependent drop down or Nested IF? Or maybe something totally different?

1. ## Completely Lost --Dependent drop down or Nested IF? Or maybe something totally different?

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.

2. ## Re: Completely Lost --Dependent drop down or Nested IF? Or maybe something totally differe

Hi, try the below formula in cell E15.

=INDEX('studiolist.xlsx'!Data,MATCH(C15,'studiolist.xlsx'!Input1,0),MATCH(D15,'studiolist.xlsx'!Input2,0))

3. ## Re: Completely Lost --Dependent drop down or Nested IF? Or maybe something totally differe

Put this in E15 and copy it down then make your choices in C and D and see if you get what you need.

``Please Login or Register  to view this content.``
Edit I had a period instead of a comma near the end of the formula.

4. ## Re: Completely Lost --Dependent drop down or Nested IF? Or maybe something totally differe

I want to ensure I am understanding you correctly.
You want the user to select the studio type(1-7,a,b) and the renter type.
Then you want the sheet to look up the price(eg. Student Renter in a Studio A is \$30). is that number correct?
Just verifying the table needed.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1