Hello, I am trying to work index match with multiple criteria for the 1st time.
I am essentially looking up 3 bits of information, one is a product code say 1234 in cell G1, then look for that same code in the stds page A2:A1400. codes are all in column a.
I then match the month G1 and look across the columns a2:be2
finally I am looking for the country in F29 and then looking into the standards page column 1 rows 2:1400.
It is difficult to explain in words and not sure how add a worksheet in here, so hopefully this makes sense. I have put the formula below. At the moment it is returning wrong formula so it I must have something wrong.
=IF(ISERROR(INDEX(Stds!$A$2:$BE$1400,MATCH($E29,Stds!$A$2:$A$1400,0),MATCH(G$1,Stds!$A$2:$BE$2,0),MATCH($F29,Stds!$I$2:$I$1400,0))),"wrong formula",INDEX(Stds!$A$2:$BE$1400,MATCH($E29,Stds!$A$2:$A$1400,0),MATCH(G$1,Stds!$A$2:$BE$2,0),MATCH($F29,Stds!$I$2:$I$1400,0)))
I am essentially looking up 3 bits of information, one is a product code say 1234 in cell G1, then look for that same code in the stds page A2:A1400. codes are all in column a.
I then match the month G1 and look across the columns a2:be2
finally I am looking for the country in F29 and then looking into the standards page column 1 rows 2:1400.
It is difficult to explain in words and not sure how add a worksheet in here, so hopefully this makes sense. I have put the formula below. At the moment it is returning wrong formula so it I must have something wrong.
=IF(ISERROR(INDEX(Stds!$A$2:$BE$1400,MATCH($E29,Stds!$A$2:$A$1400,0),MATCH(G$1,Stds!$A$2:$BE$2,0),MATCH($F29,Stds!$I$2:$I$1400,0))),"wrong formula",INDEX(Stds!$A$2:$BE$1400,MATCH($E29,Stds!$A$2:$A$1400,0),MATCH(G$1,Stds!$A$2:$BE$2,0),MATCH($F29,Stds!$I$2:$I$1400,0)))
