+ Reply to Thread
Results 1 to 6 of 6

Huge problem with the INDIRECT function, trying to create dependent drop downs

  1. #1
    Registered User
    Join Date
    06-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    12

    Huge problem with the INDIRECT function, trying to create dependent drop downs

    Okay, so, I'm trying to create a series of dependent drop down lists.
    I want to be able to select the Activity from a range of R functions, which would then give me a list of Project #'s, and then give me an option of the description.

    Example:
    I want to be able to select a code from a drop down list of these named "Activity":
    CodeR110
    CodeR210
    CodeR310
    CodeR410
    CodeR510

    If I select CodeR110 I want to be given an option of these numbers, named "CodeR110"
    701
    702
    703
    704
    706
    707
    708
    709
    710
    711
    712
    713
    714
    715

    Then when I select number 701 I should then be given another list of these named "Description"
    Executive Director
    Marketing and Communications Manager
    Office Administrator
    Operations Manager

    This function should also be able to relate back, like if I select "701" from the CodeR110 list it should give me the proper description and Activity

    I can't seem to get this to work! I can't even get CodeR110 to redirect to a listing of CodeR110 project numbers!

    Here's what I have so far:
    Pcard- Amounts Removed.xlsx

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,163

    Re: Huge problem with the INDIRECT function, trying to create dependent drop downs

    Provided the named ranges CodeR110, CodeR210, etc., match the entries in the initial drop down list, it's just:

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    06-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Huge problem with the INDIRECT function, trying to create dependent drop downs

    It's not working. Instead of giving me a drop-down list it just says: =INDIRECT($H7)

    Edit: Put the equals sign on the wrong side.
    Last edited by Quillow; 10-09-2013 at 01:29 PM.

  4. #4
    Registered User
    Join Date
    06-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Huge problem with the INDIRECT function, trying to create dependent drop downs

    Here is what the excel sheet currently looks like:
    Indirect Function.png

  5. #5
    Registered User
    Join Date
    06-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Huge problem with the INDIRECT function, trying to create dependent drop downs

    Nevermind, I just figured it out. My cell value was set to TEXT instead of GENERAL so the INDIRECT function was just displaying and not working as a function. My lists are now working! Huzzah!

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    38,163

    Re: Huge problem with the INDIRECT function, trying to create dependent drop downs

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 11-30-2012, 01:23 PM
  2. [SOLVED] Dependent Drop-Downs (Indexed)
    By BobBing in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2012, 05:33 PM
  3. Creating dependent drop downs
    By harrybelly in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 05:08 PM
  4. Dependent Drop-Downs
    By braydon16 in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 05:06 PM
  5. Dependent drop downs.
    By Mattypb in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-16-2009, 08:47 AM

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