Hi,
{=INDEX('190708'!H2:H3333;MATCH(1;('190708'!A2:A3333=Sheet1!A3)*('190708'!B2:B3333=Sheet1!B3);0);MATCH(Sheet1!H2;'190708'!2:2;0))}
In this case, row 2 and column 8 in the chosen array, the value in that cell is 9 but excel returns #REF . What is wrong?