I am writing a formula to pull data from at least 35 spreadsheets, two columns each sheet to a master sheet which are all seperate workbooks.
=IFERROR(INDEX([Abi.xlsx]List!$A$2:$G$145,MATCH($A2,[Abi.xlsx]List!$A2:$A202,0),6)),
IFERROR(INDEX([Alice.xlsx]List!$A$2:$G$145,MATCH($A2,[Alice.xlsx]List!$A2:$A202,0),6)),
IFERROR(INDEX([Andrea.xlsx]List!$A$2:$G$145,MATCH($A2,[Andrea.xlsx]List!$A2:$A202,0),6)),
IFERROR(INDEX([Ann_H.xlsx]List!$A$2:$G$145,MATCH($A2,[Ann_H.xlsx]List!$A2:$A202,0),6)),
IFERROR(INDEX([Barbara.xlsx]List!$A$2:$G$145,MATCH($A2,[Barbara.xlsx]List!$A2:$A202,0),6)),,
INDEX([Barbara.xlsx]List!$A$2:$G$145,MATCH($A2,[Barbara.xlsx]List!$A2:$A202,0),6),
INDEX([Ann_H.xlsx]List!$A$2:$G$145,MATCH($A2,[Ann_H.xlsx]List!$A2:$A202,0),6),
INDEX([Andrea.xlsx]List!$A$2:$G$145,MATCH($A2,[Andrea.xlsx]List!$A2:$A202,0),6),
INDEX([Alice.xlsx]List!$A$2:$G$145,MATCH($A2,[Alice.xlsx]List!$A2:$A202,0),6),
INDEX([Abi.xlsx]List!$A$2:$G$145,MATCH($A2,[Abi.xlsx]List!$A2:$A202,0),6)
I apologize that I cannot post the actual workbook because it has very sensitive information in it. I had a vLookup written but it took over two hours to pull all of the information.
Bookmarks