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,...
Hello Sergei.
Now it says I have too many arguments for this function. Any work arounds for this? Thanks!
I imitated on my file, formula looks like
=INDEX(INDIRECT("'[Book1]Sheet1 plus'!$F$" & MATCH(C1,B1:B7,0) & ":$F$8"),3,0)
your one shall have the same structure
