+ Reply to Thread
Results 1 to 3 of 3

Dependent Drop-Down Data Validation List Using xlookup and Table Name References

  1. #1
    Registered User
    Join Date
    08-30-2018
    Location
    Hastings, NE
    MS-Off Ver
    MS 365
    Posts
    72

    Dependent Drop-Down Data Validation List Using xlookup and Table Name References

    I saw that a dependent drop-down list can be made using xlookup, but they were using cell references. Is there a way to use xlookup data validation dependent drop-down list within a table referencing a different table?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,176

    Re: Dependent Drop-Down Data Validation List Using xlookup and Table Name References

    Try using INDIRECT. The attached workbook gives an example. The first selection is made in Cell B2. Cell B4 computes the reference. Cell B6 has the INDIRECT lookup.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,462

    Re: Dependent Drop-Down Data Validation List Using xlookup and Table Name References

    Here's a link to a webpage and video from Mynda Treacy on doing dependent drop-downs and validation using O365.

    https://www.myonlinetraininghub.com/dynamic-dependent-data-validation

+ 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. dependent data validation drop down list
    By UWBadger in forum Excel General
    Replies: 2
    Last Post: 10-22-2021, 05:13 PM
  2. [SOLVED] Data Validation Dependent Drop Down List - Source Formula too Long
    By Pereshez in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-04-2021, 06:28 PM
  3. Dependent Data Validation Drop Down List for multiple rows?
    By Howie Dean in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-16-2018, 05:31 PM
  4. Replies: 1
    Last Post: 01-14-2018, 11:04 AM
  5. Replies: 0
    Last Post: 04-24-2015, 02:27 PM
  6. [SOLVED] Data Validation - Drop-down Dependent List
    By l3il3i in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2014, 03:46 AM
  7. Replies: 2
    Last Post: 05-12-2011, 09:23 PM

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