+ Reply to Thread
Results 1 to 7 of 7

Pull data from cells based on Data Validation

  1. #1
    Registered User
    Join Date
    04-14-2014
    Location
    New Jersey
    MS-Off Ver
    Excel 2011
    Posts
    4

    Pull data from cells based on Data Validation

    Hi all, here's my situation... I am working on creating a curriculum inventory master list for several classes as well as a reporting page for each Quarter. I have 5 sheets total- Master, Quarter 1, Quarter 2, Quarter 3, Quarter 4. And 4 classes for each quarter.

    Basically what I want to do on each Quarter's reporting page is choose the correct class (have data validation already for this) and have the data for that class transfer from the Master List. So if I choose Pre K & Kindergarten, 1 set of data will be pulled and then if I choose 1st and 2nd Grade, the corresponding numbers will change.

    I've attached a sample file. The first page is my master list. The second is the reporting page. The highlighted part is where the data validation is. The red is where I would like the corresponding numbers to go

    Hope this makes sense!

    Thank you in advance for any help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,629

    Re: Pull data from cells based on Data Validation

    is this what you are after?
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,096

    Re: Pull data from cells based on Data Validation

    welcome to the forum, tmorganna515. i haven't seen humdingaling's solution but mine would be:
    =INDEX(Master!$B$6:$M$9,MATCH($E$5,Master!$A$6:$A$9,0),ROWS(E$13:E13))

    or:
    =INDEX(Master!$B$6:$M$9,MATCH($E$5,Master!$A$6:$A$9,0),MATCH(D13,Master!$B$5:$M$5,0))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  4. #4
    Registered User
    Join Date
    04-14-2014
    Location
    New Jersey
    MS-Off Ver
    Excel 2011
    Posts
    4

    Re: Pull data from cells based on Data Validation

    Y. E. S!!!! That's exactly what I was after. Thank you soooooo much! Is it possible that you could explain that out to me a little bit? Don't need a crazy detailed explanation, just enough so that I duplicate it and understand what I'm doing.

    Thanks!

  5. #5
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    312

    Re: Pull data from cells based on Data Validation

    Hi,

    Please find the attached file and tell me if it works for you.

    Thanks
    Nisha
    Attached Files Attached Files
    Thanks
    Nisha Dhawan
    Analytics Training Hub


    If you like my answer please click on * Add Reputation
    "If you can dream it, You can do it "

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,629

    Re: Pull data from cells based on Data Validation

    Beni my solution is exactly same as your 2nd formula

    tmorganna515:

    here's a brief write up someone else did on 2D index/match
    http://www.excelforum.com/tips-and-t...al-lookup.html

  7. #7
    Registered User
    Join Date
    04-14-2014
    Location
    New Jersey
    MS-Off Ver
    Excel 2011
    Posts
    4

    Re: Pull data from cells based on Data Validation

    Thanks all! You're a lifesaver!!

+ 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