Index Match multiple criteria returns incorrect value

[tygrl510]

Hi there,

I am trying to use Index Match multiple criteria function in excel but the value being returned is incorrect. Not sure how to fix it.

this is the array formula:
={IF(OR($AE4="PRIMARY";$AE4="MGDC A");$C4;INDEX(Formulary!$B$2:$B$10630;MATCH(1;($U4=Formulary!$J$2:$J$10630)*($Y4=Formulary!$N$2:$N$10630)*("PRIMARY"=Formulary!$T$2:$T$10630));0))}

the information being matched is located all in the same row.

Col C4: 11 digit numerical value
Col AE: status of the product
Formulary Col T: Matching status (in another sheet)
Formulary Col B: 11 digit numerical value (in another sheet)
Col U: Identifier (Numerical with hyphens)
Formulary Col J: Matching Identifier (in another sheet)
Col Y: Family of the product
Formulary Col N: Matching Family (in another sheet)

Any help is greatly appreciated.

Thanks,
Rio