# Pull data from cells based on Data Validation

1. ## 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!

2. ## Re: Pull data from cells based on Data Validation

is this what you are after?

3. ## 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))

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. ## 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

6. ## 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. ## Re: Pull data from cells based on Data Validation

Thanks all! You're a lifesaver!!

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

#### 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