+ Reply to Thread
Results 1 to 2 of 2

data populate according the 2 drop-down selection

  1. #1
    Forum Contributor
    Join Date
    MS-Off Ver

    data populate according the 2 drop-down selection

    Hello Experts,
    Hope you all is good, I need a help on data population, I have 2 sheets, 1st sheet have data and 2nd sheet where I need data to poplate according the 2 dropdown, I have attached screenshot and file.

    I need this Report attached to the slicers and based on the Cost Center and Project number provide the other items

    As an example a drop down index selection for both the Cost Center and the Project number.

    The other items will populate once the cost center and project number is selected

    Thanks in advance
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    MS-Off Ver

    Re: data populate according the 2 drop-down selection

    just guess>> =IFERROR(INDEX(Table1[#All],MATCH($B$1&$B$3,Table1[Cost Center]&Table1[Project ID],0)+1,MATCH(A5,'Master Sheet'!$1:$1,0)),"")

    its CSE and you might required header same for all output.

    Attached Files Attached Files

+ 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. Need Help - Data selection from drop down to auto-populate a range of cells below
    By ewb110 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 02-13-2017, 06:51 AM
  2. Populate data from drop-down list selection
    By MeCe in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 05-23-2014, 10:30 PM
  3. Populate data in cell based on drop down list selection
    By dwoodson297 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2013, 02:07 PM
  4. Auto-Populate Data Entry Format Based on Drop Down Selection. Macro?
    By pro10is4life in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2013, 01:16 AM
  5. [SOLVED] How to reference/populate a column of data based on a drop down menu selection
    By walterst in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-13-2012, 07:11 PM
  6. [SOLVED] Populate Table with data from other sheets based on drop down selection
    By nhen.enry in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 09-06-2012, 10:54 PM
  7. Populate Data (Based on Drop Down Selection)
    By jkoste03 in forum Excel General
    Replies: 5
    Last Post: 07-06-2010, 03:56 PM

Tags for this Thread


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