Index / match with several criteri

[ekslit]

Hello Guys,

I m trying to do Index / match with several criteria but the formula is not working.

{=INDEX(PointageStructure!$G$2:$G$1000,MATCH(1,(D2=PointageStructure!$B$2:$B$1000)*("Sub-task"=PointageStructure!$C$2:$C$1000)*("Analyste"=PointageStructure!$M$2:$M$1000),0))}

Do you have any clue about the issue?

thanks again for your help.

 

[nkw2306]

Try

{=INDEX(PointageStructure!$G$2:$G$1000,MATCH(1,(PointageStructure!$B$2:$B$1000=D2)*(PointageStructure!$C$2:$C$1000="Sub-task")*(PointageStructure!$M$2:$M$1000="Analyste"),0))}

 

[ekslit]

Unfortunately, Same error

 

[nkw2306]

Is there a 0 missing from the end of the formula?

 

[ekslit]

I got the problem.
I was having an extra space before A in my PointageStructure!$M$2:$M$1000 for "Analyste". i was looking for "Analyste" but if i change it to " Analyste" it works fine