+ Reply to Thread
Results 1 to 6 of 6

Populate data on another sheet based on dropdown criteria from the first sheet

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    Orlando, Florida
    MS-Off Ver
    Excel 2010
    Posts
    3

    Populate data on another sheet based on dropdown criteria from the first sheet

    I would like to be able to populate the corresponding box on sheet 2, based on the box criteria that is selected from the dropdown on sheet 1. In essence, if the box changes on sheet 1, it would automatically place the name in the new box on sheet 2. Also, is there a way to format it so that the names are placed in short columns within the box, rather than one long column? This seems like it should be straightforward, but I am not having any success with VLOOKUP or MATCH. Any help would be greatly appreciated. Sample worksheet is attached.
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Populate data on another sheet based on dropdown criteria from the first sheet

    Hi ARod0726,

    welcome to the forum.

    see the attached file where I have used below array formula:-

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Potential Grid Sample.xlsx

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    06-11-2013
    Location
    Orlando, Florida
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Populate data on another sheet based on dropdown criteria from the first sheet

    DILIPandey,

    Thanks for your excellent solution! I'm wondering if you can review a variation of what I submittted to see why it isn't working for me. To further refine where the names populate based on their Box # and Corp. Title, and then placing the name in the correct grid, I have tried adding an AND statement to your original IF statement. My updated formula is in cell B3(purple) of the attached sheet (Potential Grid Sample-original). Your formula is in cell B4 (red). I think I am close, but must have a syntax error. Any additional insight you can provide would be most helpful. Thanks again for your solution.



    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Populate data on another sheet based on dropdown criteria from the first sheet

    Okay...update your formula (b3 in Potential Grid Sample-original.xlsx‎ ) as:-
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and now it seems to be working

    Regards,
    DILIPandey
    <click on below * if this helps>

  5. #5
    Registered User
    Join Date
    06-11-2013
    Location
    Orlando, Florida
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Populate data on another sheet based on dropdown criteria from the first sheet

    Fantastic. I will have to study how the formula works without the use of an AND statement, but I appreciate your expertise. Thanks again.

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Populate data on another sheet based on dropdown criteria from the first sheet

    you are welcome...

    Cheers

    Regards,
    DILIPandey
    <click on below * if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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