What's wrong with this Index+Match formula

[toci]

Hi,

I am trying to use this Index + Match formula with 3 criteria in Sheet---> Index+Match but every time get error.

Can someone look into and correct this formula?

Thank you in advance.

[Kaper]

No attachment

[toci]

Sorry, it's here now

[Phuocam]

Try this ...
=INDEX(Pivot!$B$4:$D$100,
MATCH(A2,Pivot!$A$4:$A$100,0)+MATCH('Index+Match'!B2,OFFSET(Pivot!$A$3,MATCH(A2,Pivot!$A$4:$A$100,0),,100,),0)-1,
MATCH('Index+Match'!C2,Pivot!$B$3:$D$3))

[toci]

Try this ...
=INDEX(Pivot!$B$4:$D$100,
MATCH(A2,Pivot!$A$4:$A$100,0)+MATCH('Index+Match'!B2,OFFSET(Pivot!$A$3,MATCH(A2,Pivot!$A$4:$A$100,0),,100,),0)-1,
MATCH('Index+Match'!C2,Pivot!$B$3:$D$3))

It works on this example, but when I tried it on another new Pivot, it doesn't work.
Actually it's calculated some Values, but wrong.

[toci]

Is it possible to do this formula without OFFSET as I think it's caused a problem on another Pivot Table?

[toci]

Any new solution for this?