+ Reply to Thread
Results 1 to 3 of 3

Populate multiple cells with information based on two dependent drop down menus

  1. #1
    Registered User
    Join Date
    11-09-2021
    Location
    New Jersey, USA
    MS-Off Ver
    365
    Posts
    2

    Question Populate multiple cells with information based on two dependent drop down menus

    First of all hello everyone. I have been able to solve most issues I have by myself but this one is kicking my behind and such i am asking for help. I have seen similar posts but not exactly what i am looking for yet. I have figured out the drop down menus but for the life of me I cant make it display the results I want.
    This is a different pill(caplet, capsule, ovals, tablet etc) selector that would display the results for a container size on a packaging machine.
    Basically I have 1st drop down menu you can select the shape for the pill (lets say round). The second drop down would be for a specific round tablet (for now 10 different types. will grow as time progresses) Once the second selection is made i want the results for the specific tablet displayed in a set of cells.

    The machine has 8 lanes and each can have the same pill or each can have a different one.


    I hope i am making sense and apologize in advance. My skills with excel are absolute novice.

    Best Regards,

    Matt
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    23,826

    Re: Populate multiple cells with information based on two dependent drop down menus

    I re-organised the data as per Sheet2 (normalised form) which makes the formula much simpler

    In B8

    =INDEX(Sheet2!$C$2:$H$151,MATCH(Sheet1!B$3,Sheet2!$B$2:$B$151,0),MATCH(Sheet1!$A8,Sheet2!$C$1:$H$1,0))

    Copy down and across
    Attached Files Attached Files
    Last edited by JohnTopley; 11-09-2021 at 01:58 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    11-09-2021
    Location
    New Jersey, USA
    MS-Off Ver
    365
    Posts
    2

    Re: Populate multiple cells with information based on two dependent drop down menus

    Never in a million years would i have figured that out. Thank You very much sir.
    Best regards,

    Matt

+ 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. [SOLVED] Populate Multiple Cells based off one drop down
    By dareeldill in forum Excel General
    Replies: 7
    Last Post: 10-22-2021, 08:27 AM
  2. [SOLVED] multiple dependent double drop-down menus
    By Wietse21 in forum Excel General
    Replies: 3
    Last Post: 02-15-2018, 06:38 AM
  3. Replies: 3
    Last Post: 09-08-2016, 03:27 AM
  4. [SOLVED] Auto Populate Multiple Cells Based On One Drop Down
    By meenukekhushi in forum Excel General
    Replies: 4
    Last Post: 09-19-2014, 03:45 AM
  5. Dependent Drop Down Menus
    By Illlicit in forum Excel General
    Replies: 1
    Last Post: 09-30-2011, 01:23 PM
  6. Auto Populate Cells Dependent on Information in Previous Cell
    By senescu in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-21-2010, 11:50 AM
  7. [SOLVED] how do i set up drop down menus to populate cells in excel?
    By Louise Scott in forum Excel General
    Replies: 2
    Last Post: 05-29-2005, 04:05 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