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)
Bookmarks