maximillianrg
Board Regular
- Joined
- Aug 7, 2014
- Messages
- 75
- Office Version
- 2016
- Platform
- Windows
Hello Excel Masters
=VLOOKUP(B2,INDIRECT("'"&INDEX(MySheets,MATCH(TRUE,COUNTIF(INDIRECT("'"&MySheets&"'!$A$1:$AC$50000"),B2)>0,0))&"'!A:AC"),1,0)
- I have a workbook with 35 tabs in it and I have added a 36th tab called "Max"
- In Column A of tab Max I have a list of all other tab names
- In cell B1 of tab Max I have the word "foo"
- In cell C1 of tab Max I need the magic formula
=VLOOKUP(B2,INDIRECT("'"&INDEX(MySheets,MATCH(TRUE,COUNTIF(INDIRECT("'"&MySheets&"'!$A$1:$AC$50000"),B2)>0,0))&"'!A:AC"),1,0)