Dear Sirs,
I am very stressful how to do the link from Pivot table using index match, as I always get the error value.
What I need to do is to link to pivot table using index match matching the percentage based on the Cost Center, Job and the months.
I don't know what is the problem, it always comes to error my formula INDEX('%'!D$5:M$55,MATCH('Jul21'!U$11,'%'!A$5:A$55,0),MATCH('Jul21'!AG9,'%'!B$5:B$55,0)*MATCH(AE$3,'%'!A$2:N$2,0))
Can please someone help me to resolve this. Thanks in advance
I am very stressful how to do the link from Pivot table using index match, as I always get the error value.
What I need to do is to link to pivot table using index match matching the percentage based on the Cost Center, Job and the months.
I don't know what is the problem, it always comes to error my formula INDEX('%'!D$5:M$55,MATCH('Jul21'!U$11,'%'!A$5:A$55,0),MATCH('Jul21'!AG9,'%'!B$5:B$55,0)*MATCH(AE$3,'%'!A$2:N$2,0))
Can please someone help me to resolve this. Thanks in advance