+ Reply to Thread
Results 1 to 3 of 3

Multiple Dropdown Lists in one cell

  1. #1
    Registered User
    Join Date
    04-13-2023
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel for Microsoft 360
    Posts
    1

    Smile Multiple Dropdown Lists in one cell

    Hi Guys,

    I am trying to create a formula to allow for multiple drop down boxes in one cell based on the information in another cell.
    For example: If Cell B3 shows "(FL)" then I want a dropdown box list in cell C3 to show only items relating to (FL) which is "Flooring". Or if cell B3 shows "(WA)" then I want a dropdown box list in cell C3 to show only items relating to (WA) which is "Walls". and then if there is nothing in cell B3 I want C3 to be blank.

    Cell 3B is already a formal/calculated cell based on a dropdown list in cell A3.

    I was trying to use the below formula however within the data validation source imput, it doesn't allow for such long of a formula.

    =IF(B3="(FL)","Accessories,Linings,Tiles", ? ?, IF(B3="(J)","Accessories,Benchtops,Cabinetry,Fabrics,Hardware,Tiles", ? ?, IF(B3="(FI)","Artwork,Handrails,Lighting,Signage", ? ?, IF(B3="(WA)","Bricks,Linings,Paints,Tiles", ? ?, IF(B3="(FU)","Decoration,Fabrics,Large Pieces,Rugs", ? ?, IF(B3="(H)","Door Handles,Sanitarywear", ? ?, IF(B3="(WI)","Films,Frames,Glazing,Treatments", ? ?, IF(B3="(DO)","Films,Frames,Glazing", ? ?, IF(B3="(C)","Linings,Paints,Tiles", ""))))))))))

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,669

    Re: Multiple Dropdown Lists in one cell

    Welcome to the Forum Mikamoo!

    Is this dropdown only in one cell? Or there is a lot of rows that have this?

    Please attach a sample file so we can see all your data and provide a solution right in your file.

    The length of your formula is not the problem. You cannot provide the list items in quoted strings like that. Also what are all those " ? ?," segments in your formula? Those make your formula invalid syntactically.

    You will need to make each list a named range of cells, instead of trying to put all the lists right into your formula.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Multiple Dropdown Lists in one cell

    Pl read yellow banner on the top.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ 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] Dependent Dropdown Lists - Multiple lists
    By paula.mccall in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-18-2023, 02:07 PM
  2. Creating multiple dependent dropdown lists from the same target cell
    By oldschoolvidya in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-18-2022, 11:30 AM
  3. Multiple Dropdown lists depending ALL on 1st Dropdown choice
    By perihelio in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-04-2019, 02:15 AM
  4. Multiple Dropdown Lists in one Cell connecting 2 Workbooks
    By Hannah92 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-12-2014, 09:11 AM
  5. [SOLVED] Multiple Macros From Multiple Dropdown Lists on one sheet.
    By MagyarLou in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-29-2013, 04:33 PM
  6. Dropdown lists - multiple
    By lrussell490 in forum Access Tables & Databases
    Replies: 2
    Last Post: 09-10-2013, 03:04 PM
  7. Multiple Dropdown lists
    By lrussell490 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-10-2013, 09:18 AM

Tags for this Thread

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