+ Reply to Thread
Results 1 to 7 of 7

Pull data from cells based on Data Validation

  1. 05-07-2015, 12:03 AM #1
    tmorganna515
    tmorganna515 is offline
    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
    Reply With QuoteRegister To Reply
  2. 05-07-2015, 12:49 AM #2
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    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.
    Reply With QuoteRegister To Reply
  3. 05-07-2015, 12:54 AM #3
    benishiryo
    benishiryo is offline
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    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
    Reply With QuoteRegister To Reply
  4. 05-07-2015, 12:54 AM #4
    tmorganna515
    tmorganna515 is offline
    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!
    Reply With QuoteRegister To Reply
  5. 05-07-2015, 12:55 AM #5
    Nisha Dhawan
    Nisha Dhawan is offline
    Valued Forum Contributor
    Join Date
    05-07-2014
    Location
    India
    MS-Off Ver
    MS Office 365
    Posts
    313

    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


    If you like my answer please click on * Add Reputation
    "If you can dream it, You can do it "
    Reply With QuoteRegister To Reply
  6. 05-07-2015, 01:30 AM #6
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    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
    Reply With QuoteRegister To Reply
  7. 05-07-2015, 10:51 AM #7
    tmorganna515
    tmorganna515 is offline
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VLOOKUP / Data Validation - Pull Data Based on Drop Down Selection
    By fksms2 in forum Excel General
    Replies: 7
    Last Post: 03-06-2015, 01:53 PM
  2. Need formula to pull data based off a data validation (please help!!)
    By Thanks4helping in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2014, 11:08 PM
  3. Using an 'if' function to pull data from one cell based on data from merged cells
    By ExelDummy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-31-2014, 01:27 PM
  4. Indirect function to pull desired no of cells/row data based on data validation in Input
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-03-2013, 02:02 AM
  5. Pull Data from Multiple Columns Based On Data Validation List Selection
    By CHRISOK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2013, 11:41 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1