Results 1 to 1 of 1

multiple columns in a list (data validation)

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2013
    Location
    The Netherlands
    MS-Off Ver
    2016 x64
    Posts
    48

    Question multiple columns in a list (data validation)

    Hi,

    I use a dopdown list in a table and I want to see multiple columns in the dropdown.
    See example attached.

    I have managed to get this in a single field in a form. But what I need here is a similar solution only then in a table, so that it applies to every row in a column.
    I would expect that there some kind of formula that can be used in the "data validation" function.

    Thanks

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Validation List looking at two columns
    By pchugh in forum Excel General
    Replies: 4
    Last Post: 05-20-2018, 08:23 PM
  2. [SOLVED] Display columns in excel based on Data validation list in multiple columns
    By tejboyd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2017, 09:17 PM
  3. Replies: 4
    Last Post: 05-18-2017, 04:27 AM
  4. [SOLVED] how to use data validation with a delimited list (or use multiple columns)
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-14-2016, 10:39 AM
  5. Exclude items from Data Validation List based on another columns data
    By amartin575 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-19-2013, 11:53 AM
  6. Pull Data from Multiple Columns Based On Data Validation List Selection
    By CHRISOK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2013, 11:41 PM
  7. [SOLVED] data validation list from two columns
    By otinky in forum Excel General
    Replies: 1
    Last Post: 03-21-2005, 10:06 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