+ Reply to Thread
Results 1 to 3 of 3

Unable to use named table to create drop-down list using data validation

  1. #1
    Registered User
    Join Date
    10-01-2020
    Location
    Singapore
    MS-Off Ver
    Microsoft 2019
    Posts
    1

    Unable to use named table to create drop-down list using data validation

    I am using M1 macbook and am trying to create a drop-down list using an existing table that is named by excel keeps on showing that there is a problem with the formula. Is there anything I have done wrongly or does macbook not support this function?

    What I have done:
    1. Create a table
    2. Change the name of the table

    I have attached the excel & inserted a picture of what I want & what error I have.

    Thanks for the help in advance!

    Forum Version.xlsx

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Unable to use named table to create drop-down list using data validation

    Can you explain - in words - what you are doing? Your pics dont make much sense to me
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    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,209

    Re: Unable to use named table to create drop-down list using data validation

    Neither Table1 nor Team_table are in your posted file so how do you expect an answer to your query if this key data is missing?
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. [SOLVED] Remove Blanks In Data Validation Drop Down List (Dynamic Named Range)
    By d365b in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2021, 03:55 PM
  2. [SOLVED] VBA Possibly: Searchable list while using data validation through a named range in a table
    By AMoreno in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 10-03-2019, 10:47 AM
  3. Replies: 3
    Last Post: 10-23-2017, 08:37 PM
  4. [SOLVED] Data validation list in a table, reference a named range on another worksheet
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-01-2017, 11:24 AM
  5. how to create data validation drop-down list based on three conditions...
    By jiaron_1230 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-20-2016, 05:06 AM
  6. Replies: 5
    Last Post: 09-26-2013, 11:45 AM
  7. Replies: 0
    Last Post: 09-08-2011, 02:22 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