Spreadsheet: 702193d1604152477-nested-if-has-currently-45-sub-components-want-to-streamline-the-formula-process-long-nested-if-with-2-and-criteria
Sheet: Matrix

Group 1 | Group 2 | Group 3 | [NAME] |  | Combinations |  |  | [NAME] |  | String | Colum F | String | Column G | String | Column H | String | Colum I | String | Concatenated [plus "=" plus 45 ")"]
1 | 1 | 1 |  |  | 1 | 1 | 1 | 1 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 1 | 2 | 2 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 1 | 3 | 3 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 1 | 4 | 4 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 1 | 5 | 5 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 2 | 1 | 6 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 2 | 2 | 7 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 2 | 3 | 8 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 2 | 4 | 9 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 2 | 5 | 10 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 3 | 1 | 11 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 3 | 2 | 12 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 3 | 3 | 13 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 3 | 4 | 14 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 1 | 3 | 5 | 15 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 1 | 1 | 16 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 1 | 2 | 17 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 1 | 3 | 18 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 1 | 4 | 19 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 1 | 5 | 20 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 2 | 1 | 21 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 2 | 2 | 22 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 2 | 3 | 23 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 2 | 4 | 24 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 2 | 5 | 25 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 3 | 1 | 26 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 3 | 2 | 27 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 3 | 3 | 28 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 3 | 4 | 29 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 2 | 3 | 5 | 30 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 1 | 1 | 31 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 1 | 2 | 32 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 1 | 3 | 33 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 1 | 4 | 34 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 1 | 5 | 35 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 2 | 1 | 36 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 2 | 2 | 37 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 2 | 3 | 38 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 2 | 4 | 39 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 2 | 5 | 40 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 3 | 1 | 41 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 3 | 2 | 42 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 3 | 3 | 43 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 3 | 4 | 44 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ), |  | ,
 |  |  |  |  | 3 | 3 | 5 | 45 |  | IF(AND($A$2= |  | , $B$2= |  | , $C$2= |  | ),