Hi All, hope you are having a good day..
I have used Index and match function to pick up data from a data base. However what I need is to sum up and values of multiple mathers.
Below, in the left is the data base, in the right is the picked up values for 'GL1-Brand1-Jan'.
But in the data base for 'Jan & Brand1' there are two GL1 values, 300 and 200, so I need to get the look up value sumed up to have the result of 500. (Formula used --> =INDEX($D$3:$F$7,MATCH($I3,$C3:$C7,0),MATCH(J$1&J$2,$D$1:$F$1&$D$2:$F$2,0)). Pls help, tahnks
I have used Index and match function to pick up data from a data base. However what I need is to sum up and values of multiple mathers.
Below, in the left is the data base, in the right is the picked up values for 'GL1-Brand1-Jan'.
But in the data base for 'Jan & Brand1' there are two GL1 values, 300 and 200, so I need to get the look up value sumed up to have the result of 500. (Formula used --> =INDEX($D$3:$F$7,MATCH($I3,$C3:$C7,0),MATCH(J$1&J$2,$D$1:$F$1&$D$2:$F$2,0)). Pls help, tahnks
| Jan | Jan | Jan | Jan | Jan | Jan | ||||
| Brand1 | Brand2 | Brand3 | Brand1 | Brand2 | Brand3 | ||||
| GL1 | 300 | 500 | 300 | GL1 | 300 | 500 | 300 | ||
| GL2 | 400 | 700 | 700 | ||||||
| GL3 | 500 | 400 | 900 | ||||||
| GL1 | 200 | 600 | 900 | ||||||
| GL2 | 100 | 300 | 200 |