Hi There,
Is it possible to link my Index Match with Indirect formula (G3), which is already good, to multiple lines.
Currently my G2 in linked to C90, but I have more lined in which the codes could be, C90-C100 (see yellow highlighted cells). So the formula is not only applicable to row 90.
Would be great if you can help. Thanks!
Is it possible to link my Index Match with Indirect formula (G3), which is already good, to multiple lines.
Currently my G2 in linked to C90, but I have more lined in which the codes could be, C90-C100 (see yellow highlighted cells). So the formula is not only applicable to row 90.
Would be great if you can help. Thanks!
Product Costing Master 251120.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Mince Giv | Mince Giv | Mince Giv | ||||||||
2 | COS | Raw Material Code | Description 1 | Description 2 | Supplier | Cost/kg | MFPC050.V1 | MFPC048 | MFPC057 | ||
3 | Ingredients | RM008 | 554M - EXCEL FIT HI-CEL 554M (METHYL CELLULOSE SOLUTION) | FIT | 10.95 | 0.1752 | |||||
4 | Ingredients | RM011.001 | SUPRO 500 - SOYA PROTEIN ISOLATE - SUPRO 500 | Soya protein | FIT | 2.95 | 0.2643 | ||||
5 | Ingredients | RM014 | R00003 - REFINED RAPESEED OIL | Oil | Kerfoot | 1.2337 | 0.1875 | ||||
6 | Ingredients | RM018 | ORAFTI HP | Kreglinger | 4.78 | 0.0956 | |||||
7 | Ingredients | RM010.001 | 4410 - TEXTURED SOYA PROTEIN CONCENTRATE - DUPONT | Soya protein | FIT | 3.38 | - | ||||
8 | Ingredients | RM010.003 | CONTEX 18 | Other | Solbar | 1.84 | - | ||||
CoS FLAT |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G3:G8 | G3 | =SUMIFS(INDEX(INDIRECT("'"&G$1&"'!$C$8:$Y$100"),0,MATCH(G$2,INDIRECT("'"&G$1&"'!$C90:$Y90"),0)),INDIRECT("'"&G$1&"'!$B$8:$B$100"),$C3) |
Product Costing Master 251120.xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
87 | ||||||||||||||||
88 | ||||||||||||||||
89 | ||||||||||||||||
90 | Product codes | MFPC050.V1 | MFPC048 | MFPC071 | ||||||||||||
91 | MFPC057 | |||||||||||||||
92 | MFPC131 | |||||||||||||||
93 | MFPC060 | |||||||||||||||
94 | MFPC104 | |||||||||||||||
95 | MFPC106 | |||||||||||||||
96 | ||||||||||||||||
97 | ||||||||||||||||
98 | ||||||||||||||||
99 | ||||||||||||||||
100 | ||||||||||||||||
101 | ||||||||||||||||
102 | ||||||||||||||||
103 | ||||||||||||||||
Mince Giv |