Results 1 to 3 of 3

Thread: Lookup Populate Grouped Information Based On DropDown Selection

  1. #1
    Member
    Join Date
    Dec 2012
    Posts
    78
    Rep Power
    12

    Lookup Populate Grouped Information Based On DropDown Selection

    Hello

    Can the following be done with Dropdown Lists.I want to make a dropdown list with 30 groups.I have 3 example groups in excel 2010 spreadsheet attached

    I need the dropdown list in cell B6 - prefer not to use code if possible

    From the dropdown list i can select say Smiths Wholesale in B6 and it then displays the Name,Phone,Fax and Email exactly like the spreadsheet....Can i have all the groups in Sheet 1 and the Dropdown list will be in Sheet 2

    Thanks
    Rich
    Excel 2010
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Try this..

    Make a list of your group names....

    Use Index+Match to lookup for the selected group, and then populate the corresponding values below that
    Attached Files Attached Files
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Member
    Join Date
    Dec 2012
    Posts
    78
    Rep Power
    12
    Thank you

Similar Threads

  1. Sum Based on Lookup
    By wsadaqa in forum Excel Help
    Replies: 3
    Last Post: 05-20-2013, 09:17 AM
  2. Replies: 1
    Last Post: 05-03-2013, 04:41 PM
  3. Change Display Range Based On Change of Dropdown Values
    By rich_cirillo in forum Excel Help
    Replies: 2
    Last Post: 03-29-2013, 04:58 AM
  4. Replies: 14
    Last Post: 01-26-2013, 04:58 AM
  5. Lookup Based on Criteria
    By maruthi in forum Excel Help
    Replies: 2
    Last Post: 02-15-2012, 08:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •