Hello
I am trying to make my INDEX MATCH formula dynamic for the sheet reference however I receive an error when I make the first MATCH argument INDIRECT("'"&B$2&"'!"&"$B$9:$AO$256"), dynamic using INDIRECT:
When I use the following formula, I receive the N/A error:
=INDEX(INDIRECT("'"&B$2&"'!"&"$B$9:$AO$256"),MATCH('Tax Analysis by Entity'!$C4,INDIRECT("'"&B$2&"'!"&"$B$9:$AO$256"),0),MATCH('Tax Analysis by Entity'!D$2,INDIRECT("'"&B$2&"'!"&"$B$8:$AO$8"),0))
When I remove the first INDIRECT argument from the first MATCH the formula returns the correct result however the first MATCH sheet reference argument is not dynamic:
=INDEX(INDIRECT("'"&B$2&"'!"&"$B$9:$AO$256"),MATCH('Tax Analysis by Entity'!$C4,'2018 Income Statement'!$B$9:$B$256,0),MATCH('Tax Analysis by Entity'!D$2,INDIRECT("'"&B$2&"'!"&"$B$8:$AO$8"),0))
Can somebody assist me to resolve this problem so that all sheet references are dynamic?
Bookmarks