Teleporpoise
New Member
- Joined
- May 23, 2019
- Messages
- 31
I have this equation in my document that references a sheet in the same workbook
=OFFSET(INDIRECT("feature[#headers]"),MATCH(I7,INDIRECT("feature[op '#]"),0),1,COUNTIF(INDIRECT("feature[op '#]"),I7),1)
But the data it is referencing is also referenced by multiple other workbooks. At the moment every workbook has a copy of that data and references its copy, but this is not a good longterm solution. Can I have this equation referenced from a separate workbook?
=OFFSET(INDIRECT("feature[#headers]"),MATCH(I7,INDIRECT("feature[op '#]"),0),1,COUNTIF(INDIRECT("feature[op '#]"),I7),1)
But the data it is referencing is also referenced by multiple other workbooks. At the moment every workbook has a copy of that data and references its copy, but this is not a good longterm solution. Can I have this equation referenced from a separate workbook?