Results 1 to 3 of 3

Thread: Lookup Populate Grouped Information Based On DropDown Selection

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 04-02-2013, 10:19 PM #1
    rich_cirillo
    rich_cirillo is offline
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sum Based on Lookup
    By wsadaqa in forum Excel Help
    Replies: 3
    Last Post: 05-20-2013, 09:17 AM
  2. Change chart source based on selection in form control list box in excel
    By naveen_itm in forum Excel Help
    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. Best way to cross populate multiple arrays based on data entry into a single array?
    By Orestees in forum Excel Help
    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

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
  •  

Forum Rules