Hello,
Can you help me
I do not want to use INDIRECT (). I want to use INDEX and MATCH.But i do not know how.
There is a link between bills.xlsx and evaluation.xlsx.
I need to manually change the matrix area in the file evaluation.xlsx (MatrixArea) monthly.
In the file Evaluations.xlsx I have to have the following results in the cells: cell C12 = 5, cell C13 = 7, cell C14 = 2 when I type in MatrixArea (A4 and D6)
In the file evaluation.xlsx, I have to get the following results in the cells: cell C12 = 2, cell C13 = 3, cell C14 = 9 when I type in MatrixArea (A11 and D13)

Config:
C12= VLOOKUP($A12;INDIRECT("'[bills.xlsx]2016'!"&MatrixArea!C6&":"&MatrixArea!D6&"");4;0)
C13= VLOOKUP($A13;INDIRECT("'[bills.xlsx]2016'!"&MatrixArea!C6&":"&MatrixArea!D6&"");4;0)
C14=VLOOKUP($A14;INDIRECT("'[bills.xlsx]2016'!"&MatrixArea!C6&":"&MatrixArea!D6&"");4;0)

bills.JPGevaluation MatrixArea.JPGevaulation -report.xlsx.JPG


Thanks