Error in index+match multiple criteria

[AynRand]

Dear excel experts,

I'm struggling to complete successfully one index formula.

I need to return a value from a sheet, matching three different criteria.

I want to find in sheet "VICEPROCESS NE DN" in column S a value, based on the match of three values in columns D,E and F. That have to be the same values than in sheet "VICEPROCESS NE AN" ​

this is the formula I'm using:

{=INDEX('VICEPROCESS NE DN'!$D$2:S4236;MATCH(1;(D2='VICEPROCESS NE DN'!D:D)*(E2='VICEPROCESS NE DN'!E:E)*(F2='VICEPROCESS NE DN'!F:F);0)*16)}

anyone sees an error on the formula?

If anyone could help I will be so greatfull

Kind regards

 

[steve the fish]

Try:

=INDEX('VICEPROCESS NE DN'!$D$2:$S$4236;MATCH(1,(D2='VICEPROCESS NE DN'!$D$2:$D$4236)*(E2='VICEPROCESS NE DN'!$E$2:$E$4236)*(F2='VICEPROCESS NE DN'!$F$2:$F$4236);0);16)

 

[AynRand]

Man,it works perfectly!! :D you made my day, thanks!