+ Reply to Thread
Results 1 to 5 of 5

Issue creating a dependent drop down list with indirect function

  1. 05-03-2022, 04:49 PM #1
    Grilleman
    Grilleman is offline
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    245

    Issue creating a dependent drop down list with indirect function

    Hello,

    Using Win 7 and running Excel 2010. Sample workbook attached.

    I'm trying to display a list of tees in column G based on the golf course selected in column F. I can't seem to get my indirect function to work.


    I've named each range as follows:

    Column A: Range Name "Club" = the golf club names.......
    Column B: Range Name "BV" = the tees associated with Bull Valley Golf Club......
    Column C: Range name "Mak" = the tees associated with Makray Memorial Golf Club

    Cells F2 presents a list of the golf club names contained in my range named "Club".

    My problem is with the validation source formula for column G. Indirect formula not working.

    What am I doing wrong here?

    Thanks for any help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-03-2022, 05:16 PM #2
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,197

    Re: Issue creating a dependent drop down list with indirect function

    There is no named range relating to G2

    Try

    =INDIRECT(VLOOKUP(G2,$A$2:$B$3,2,0))

    See attached.
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 05-03-2022, 05:27 PM #3
    Grilleman
    Grilleman is offline
    Forum Contributor
    Join Date
    04-11-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    245

    Re: Issue creating a dependent drop down list with indirect function

    Thanks, John. One question though. Why does the indirect formula I have in my original workbook not work? I watched a video demonstrating the formula does work. Is it because I'm using Excel 2010?
    Reply With QuoteRegister To Reply
  4. 05-04-2022, 01:23 AM #4
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,197

    Re: Issue creating a dependent drop down list with indirect function

    In your file the DV is "=INDIRECT($F$3)" where f3 is "Bull Valley Golf Club". there is no named range with the latter name so the DV will not work. Your BV range is really the "Bull Valley Golf Club". named range

    You also used "Mak" rather than "Makray" for a named range so that would also cause problems.

    So note that a named range for "Bull Valley Golf Club" would be "Bull_Valley_Golf_Club" with underscores replacing the blanks: so the DCV would be

    =INDIRECT(SUBSTITUTE(F3," ","_"))
    Reply With QuoteRegister To Reply
  5. 05-04-2022, 02:23 AM #5
    menem
    menem is offline
    Forum Expert
    Join Date
    09-30-2019
    Location
    Chiangmai, Thailand
    MS-Off Ver
    Office 2016, Excel 2019
    Posts
    1,234

    Re: Issue creating a dependent drop down list with indirect function

    If you don't mind to try alternative solution instead of using INDIRECT (or Name Rang solution).
    Please review posts in my signature.

    Regards.
    My English is very poor, so please be patient >_<"

    My Dynamic Related Dropdown post:
    https://www.excelforum.com/excel-for...ml#post5657376
    https://www.excelforum.com/excel-for...ml#post5655711
    https://www.excelforum.com/excel-for...ml#post5655762
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating Dependent Drop Down List using information from multiple worksheets
    By lmanusakis in forum Excel General
    Replies: 1
    Last Post: 11-11-2020, 03:38 PM
  2. Dependent drop down list. Why is INDIRECT formula not working.
    By TRAZ6666 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-09-2020, 07:15 AM
  3. INDIRECT function for Dependent Drop Down on separate sheet
    By hieuabc in forum Excel General
    Replies: 1
    Last Post: 07-14-2020, 04:31 AM
  4. INDIRECT function for Dependent Drop Down on separate sheet
    By StaffsLebowski in forum Excel General
    Replies: 8
    Last Post: 05-18-2020, 12:45 PM
  5. [SOLVED] Huge problem with the INDIRECT function, trying to create dependent drop downs
    By Quillow in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-09-2013, 03:27 PM
  6. [SOLVED] Creating cells dependent on a drop-down list
    By FraserP in forum Excel General
    Replies: 3
    Last Post: 05-11-2012, 01:47 PM
  7. VBA code for creating dependent drop down list
    By singhabhijitkumar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-26-2010, 08:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1