+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    03-28-2013
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    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.
    Last edited by AtlanticGeneral; 03-29-2013 at 11:48 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    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))
    If I've been of help, please hit the star

  3. #3
    Forum Contributor
    Join Date
    09-27-2012
    Location
    Florida
    MS-Off Ver
    Excel XP to 2013
    Posts
    342

    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.
    Last edited by Tank997; 03-29-2013 at 12:06 PM.
    Tom S.
    ↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the left
    If your question is resolved, mark it SOLVED using the thread tools.

  4. #4
    Registered User
    Join Date
    03-22-2013
    Location
    North Carolina, USA
    MS-Off Ver
    Office 2010 Professional
    Posts
    8

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

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