Hello Guys,
I m trying to do Index / match with several criteria but the formula is not working.
Do you have any clue about the issue?
thanks again for your help.
I m trying to do Index / match with several criteria but the formula is not working.
VBA Code:
{=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.