i have a workbook w/ 9 data tabs and an collaboration tab. What i am trying to do is pull the data from the 9 data tabs and insert the data on the collaboration tab. the data tabs are named by a group of people but the columns are all named the same in each tab (just different people in each). I have been trying without success to get this to work. I tried both index match and vlookup with the indirect function but keep getting errors. i have created a named range to list out all the tab names and used in the indirect function but i don't know what i am doing wrong. below are both the vlookup as well as the index match formulas i have tried. ANY feedback would be great!
=INDEX(INDIRECT("'"&tabs&"'!a1:y100"),MATCH(A3,INDIRECT("'"&tabs&"'!a1:a100"),0),MATCH(B1,INDIRECT("'"&tabs&"'!a1:y1"),0))
=VLOOKUP(A4,indirect("'"&tabs&"'!$A$3:$Y$17"),2,FALSE)
Bookmarks