+ Reply to Thread
Results 1 to 2 of 2

I need to create a dropdown list but want to automatically include adjacent colums

  1. #1
    Registered User
    Join Date
    05-07-2016
    Location
    Salem, OR
    MS-Off Ver
    Office 365
    Posts
    1

    Question I need to create a dropdown list but want to automatically include adjacent colums

    Can someone help me figure out how to do this

    A B C D
    1Entrees LS LC GF
    2Swiss Steak x x x
    3BBQ Chicken x x x


    I WANT TO CREATE A DROPDOWN LIST BASED ON ITEMS IN A2:A3 NAMED ENTREES, BUT ON MY FORM I WANT TO ADD DATA FROM B,C,D TO MY SHEET?

    HOW CAN I DO THIS SO THAT IT AUTOMATICALLY FILLS IF THERE IS INFORMATION IN THE CELLS

    fOR EXAMPLE I CHOOSE SWISS STEAK FROM DROP DOWN LIST, THIS ITEM SHOWS IT IS AVAILABLE IN LS (LOW SODIUM) LC (LOW CARB) GF ( GLUTEN FREE) BECAUSE THERE IS A X IN THE COLUMN. I NEED THIS TO BE INCLUDED WHEN THE ITEM IS SELECTED IN THE DROP DOWN BOX AND INCLUDE INFORMATION ON THE SHEET. I JUST CANT SEEM TO FIGURE THIS OUT.
    Last edited by caremeals; 05-07-2016 at 01:41 PM.

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: I need to create a dropdown list but want to automatically include adjacent colums

    One way...

    Data Range
    A
    B
    C
    D
    1
    Entrees
    LS
    LC
    GF
    2
    Swiss Steak
    x
    x
    3
    BBQ Chicken
    x
    x
    x
    4
    ------
    ------
    ------
    ------
    5
    6
    7
    8
    9
    10
    LS
    LC
    GF
    11
    Swiss Steak
    x
    x


    A11 is your drop down list.

    This formula entered in B11:

    =T(INDEX($B$2:$D$3,MATCH($A11,$A$2:$A$3,0),COLUMNS($B11:B11)))

    Copy across to D11
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Replies: 3
    Last Post: 11-13-2015, 05:10 AM
  2. Create dropdown list in Excel that will only list unique entries
    By MissAudrey in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-22-2015, 04:56 PM
  3. Remove Dropdown List if Text in adjacent cell
    By brent_milne in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2014, 05:28 PM
  4. Automatically List Dropdown
    By ec4excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2014, 11:20 AM
  5. Show specific rows and colums on dropdown list selection
    By info5 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-07-2012, 02:22 AM
  6. Populating numerical values in adjacent cell from using a dropdown list
    By up_and_under in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-30-2010, 10:30 AM
  7. Replies: 5
    Last Post: 03-12-2008, 05:01 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