# Vlookup, indirect, index, match, countif from multiple sheet & with two criteria

1. ## Vlookup, indirect, index, match, countif from multiple sheet & with two criteria

In excel 2007. I have multiple sheets. In those sheet i have in a2, a3, a4 up to a13 column student name.
In column B1 to AF1 i have dates. This structure in all sheet is same. column B2 : AF13 i enter data.

Now in summary sheet i have pull those data with specific student name & date. (structure is same as per other all sheet)
I define all sheet name as : listsheet
Please note student name from a2:a13 (vertical) & date from b1:af13 (horizontal)
I am trying below formula, but i can't pull specific data from multiple sheet with two criteria (student name & date is criteria)
=VLOOKUP(\$A2,INDIRECT("'"&INDEX(LISTSHEET,MATCH(1,--(COUNTIF(INDIRECT("'"&LISTSHEET&"'!\$A\$1:\$AF\$13"),\$A2)>0),0))&"'!\$A\$1:\$AF\$13"),{2,3},FALSE)

2. ## Re: Vlookup, indirect, index, match, countif from multiple sheet & with two criteria

I think it would be easier to offer suggestions if you upload a small (clean) sample of what you are working with, and show samples what your expected outcome would look like.

3. ## Re: Vlookup, indirect, index, match, countif from multiple sheet & with two criteria

sample file attach.
In summary sheet required output.

4. ## Re: Vlookup, indirect, index, match, countif from multiple sheet & with two criteria

Thanks

You may need to adjust the ranges here, but it looks like you only have 13 rows? Use this, copied down and across...

=INDEX(INDIRECT("'"&TEXT(B\$1,"MMMYY")&"'!\$B\$2:\$AF\$13"),MATCH(\$A2,INDIRECT("'"&TEXT(B\$1,"MMMYY")&"'!\$A\$2:\$A\$13"),0),MATCH(B\$1,INDIRECT("'"&TEXT(B\$1,"MMMYY")&"'!\$B\$1:\$AF\$1"),0))

5. ## Re: Vlookup, indirect, index, match, countif from multiple sheet & with two criteria

Great job, Ford!! I'm saving this one!

Regards,
Dave

Edit: Oh yes, thanks for posting this one.

6. ## Re: Vlookup, indirect, index, match, countif from multiple sheet & with two criteria

Originally Posted by avk
sample file attach.
In summary sheet required output.
Very well thought out workbook. Great job!

7. ## Re: Vlookup, indirect, index, match, countif from multiple sheet & with two criteria

Flame, thanks for the kind words and the feedback

Reps from members not even involved in the thread are especially appreciated

(Its really not as fancy as it looks though )

8. ## Re: Vlookup, indirect, index, match, countif from multiple sheet & with two criteria

Dear FDibbins : Firstly sorry for delay in reply. Actually i log in today morning 11.00 am.
Yes great job done. I appreciates your efforts. Thanks.

9. ## Re: Vlookup, indirect, index, match, countif from multiple sheet & with two criteria

@ avk, not a problem - we are all in different time zones, Im just happy we were able to resolve your question for you, and thanks for the feedback

##### Users Browsing this Thread

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