+ Reply to Thread
Results 1 to 6 of 6

Auto-populate fields based on drop down selection

  1. #1
    Registered User
    Join Date
    04-02-2015
    Location
    London
    MS-Off Ver
    Ecel 2013
    Posts
    13

    Auto-populate fields based on drop down selection

    Hi there,

    I have created a 3 tiered drop-down list with data validation, using different ranges.

    My first drop down is looking at Product, then Country, then Industry. These are all linked via =indirect and ranges.

    Depending on the selection of all three individual fields a cell shall be auto-populated with a number value.

    I have all number values for each individual selected combination, but I am not sure how to link this/ create a table that will enable me to auto-populate a cell like this in the easiest way.

    I really need some help!

    Thanks

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Auto-populate fields based on drop down selection

    We'd need to see how your data is setup to be able to give detailed help. Can you post a sample workbook?
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    04-02-2015
    Location
    London
    MS-Off Ver
    Ecel 2013
    Posts
    13

    Re: Auto-populate fields based on drop down selection

    Table1.xlsx

    I attached an example table below.

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Auto-populate fields based on drop down selection

    The easiest way to accomplish this without going the VBA and still having a contained, non-volatile formula would be to format your values table as seen in the example. From there, it is a simple array index/match to pull the correct results.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-02-2015
    Location
    London
    MS-Off Ver
    Ecel 2013
    Posts
    13

    Re: Auto-populate fields based on drop down selection

    Hi Mcmahobt,

    Thanks, it seems to be working great for the example with product a for brazil for any industry!

    However, the drop down menu for countries is not working anymore? Any advise?

    Thanks

  6. #6
    Registered User
    Join Date
    04-02-2015
    Location
    London
    MS-Off Ver
    Ecel 2013
    Posts
    13

    Re: Auto-populate fields based on drop down selection

    Just figured it out. Thanks a lot!

+ 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. Auto populate fields based on the model # in the drop down
    By smithashankar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-14-2014, 06:20 AM
  2. Auto-populate field based on drop down box selection
    By nicfarrell in forum Excel General
    Replies: 7
    Last Post: 01-21-2013, 12:47 AM
  3. [SOLVED] Auto populate fields based on data in a drop down box from a second sheet
    By Grazzio in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2012, 10:34 AM
  4. Auto-populate fields based on selection from dropdown?
    By Aswert in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-20-2009, 03:26 PM
  5. Replies: 3
    Last Post: 01-13-2006, 04:30 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