Spreadsheet: 687713d1595358151-dynamic-path-reference-within-formula-function-case
Sheet: Sheet1

Col Header 1 | Col [NAME] | Col Header 3 | Col Header 4 | Col Header 5 | Index | [NAME]
=INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | 4 | Y:\Folder\[ReportQ1.xls]Master'!
=INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | 8 | Y:\Folder\[ReportQ2.xls]Master'!
=INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | 6 | Y:\Folder\[ReportQ2.xls]Master'!
=INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | 1 | Y:\Folder\[ReportQ2.xls]Master'!
=INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | =INDEX($G2&(Data range on other sheet), MATCH($F2,G2&(column range on other sheet),0),MATCH(A$1,(Static Row range on other sheet),0)) | 5 | Y:\Folder\[ReportQ3.xls]Master'!