Good Afternoon,
I used the formula below which is derived from the website linked here: https://www.myonlinetraininghub.com/excel-vlookup-multiple-sheets
=VLOOKUP($A$1,INDIRECT("'"&INDEX(ActivePrograms,MATCH(1,--(COUNTIF(INDIRECT("'"&ActivePrograms&"'!$A$1:$G$34"),$A$1)>0),0))&"'!$A$1:$G$34"),2,FALSE)
The problem is the formula above returns the first result it finds over and over. I need it to recognize the first result and then post the second result in the row below. What would be a way to do this?
Any help is greatly appreciated. Thank you
Sean
Hi Sean,
You can try modifying this lookup and return multiple values formula to lookup multiple sheets, but now that we have Power Query I don't recommend that approach.
It would be better to fix the layout of your data and consolidate the data across multiple sheets into one table with Power Query. Then you can use a PivotTable to easily extract the results.
If you want to upload a sample file I'll show you how.
Mynda
