+ Reply to Thread
Results 1 to 4 of 4

Drop Down List to return multiple results in multiple cells

  1. #1
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2010
    Posts
    25

    Drop Down List to return multiple results in multiple cells

    Hi All,


    I'm rather new to Excel and would like some help with something that might appear very simple to many.

    I have created a drop down list with 4 choices on the first sheet. On the second sheet, there are 4 columns of data following the choices in the drop down list. I would like to know what is the most efficient way to have each choice in the drop down menu return their respective 4 results in sheet #1.

    For example: I would like when I select the choice "Risks" in the menu, to see "AAAA", "BBBB", "CCCC", and "DDDD" appear in the 4 cells below.

    See attachment for my file.

    Thanks for your help with this!


    Joshua
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-18-2013
    Location
    Arlington, Texas
    MS-Off Ver
    Excel 2007
    Posts
    60

    Re: Drop Down List to return multiple results in multiple cells

    see if this works?
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,571

    Re: Drop Down List to return multiple results in multiple cells

    The fact that you are merging cells makes it a bit more complex but put this in A2 copied down

    =VLOOKUP($A$1,Sheet2!$A$1:$E$4,INT((ROWS($A$1:A1)-1)/4+2),FALSE)
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Drop Down List to return multiple results in multiple cells

    Thanks a lot guys, that works perfectly!

+ 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. Search by Multiple Criteria, Put All Results into Drop Down List
    By Jeff C in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-27-2012, 02:54 PM
  2. [SOLVED] VLOOKUP multiple results in a drop down list
    By tnfire in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 07-14-2012, 12:31 PM
  3. Search multiple sheets and return list of multiple results
    By Abuck in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-07-2012, 11:59 AM
  4. Vlookup, multiple results and drop down list?
    By korvo in forum Excel General
    Replies: 3
    Last Post: 09-06-2010, 11:01 AM
  5. Replies: 3
    Last Post: 07-06-2010, 05:30 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