Forum Discussion
Index Match Error
I have an excel document with 20+ different tables. I would like my Excel formulas in my working sheet to find each table and then extract the data. =INDEX('[Inputs.xlsx]Table 1'!$A$1:$BV$10000,...
Hi Charlotte,
You may use INDIRECT
=INDEX(INDIRECT("'[Inputs.xlsx]Table 1'!$A$" & MATCH(...)), ..
but it works if only your file is opened.
Why don't you use Excel tables with structured references?
Thanks. I have not used structured references because I have about 100 input files (which change every year) and I want to avoid changing each one.
