Spreadsheet: 688451d1595795810-populate-cells-based-on-values-in-columns-please-see-attached-sample-sheet
Sheet: Recipe

 |  |  |  |  |  |  |  |  |  |  | Raw Ingredients | Cumin | Paprika | Salt | Butter | [NAME] | Vinegar | [NAME] | Pepper | Ghee | Ingredient 10 | Ingredient 11 | Ingredient 12 | Ingredient 13 | Ingredient 14 | Ingredient 15 | Ingredient 16 | Ingredient 17 | Ingredient 18 | Ingredient 19 | Ingredient 20 | Ingredient 21 | Ingredient 22 | Ingredient 23 | Ingredient 24 | Ingredient 25 | Ingredient 26 | Ingredient 27 | Ingredient 28 | Ingredient 29 | Ingredient 30 | Ingredient 31 | Ingredient 32 | Ingredient 33 | Ingredient 34 | Ingredient 35 | Ingredient 36 | Ingredient 37 | Ingredient 38 | Ingredient 39 | Ingredient 40 | Ingredient 41 | Ingredient 42 | Ingredient 43 | Ingredient 44 | Ingredient 45 | Ingredient 46 | Ingredient 47 | Ingredient 48 | Ingredient 49 | Ingredient 50 | Ingredient 51 | Ingredient 52 | Ingredient 53 | Ingredient 54 | Ingredient 55 | Ingredient 56 | Ingredient 57 | Ingredient 58 | Ingredient 59 | Ingredient 60 | Ingredient 61 | Ingredient 62 | Ingredient 63 | Ingredient 64 | Ingredient 65 | Ingredient 66 | Ingredient 67 | Ingredient 68 | Ingredient 69 | Ingredient 70 | Ingredient 71 | Ingredient 72 | Ingredient 73 | Ingredient 74 | Ingredient 75 | Ingredient 76 | Ingredient 77 | Ingredient 78 | Ingredient 79 | Ingredient 80 | Ingredient 81 | Ingredient 82 | Ingredient 83 | Ingredient 84 | Ingredient 85 | Ingredient 86 | Ingredient 87 | Ingredient 88 | Ingredient 89 | Ingredient 90 | Ingredient 91 | Ingredient 92 | Ingredient 93 | Ingredient 94 | Ingredient 95 | Ingredient 96 | Ingredient 97 | Ingredient 98 | Ingredient 99 | Ingredient 100 | Ingredient 101 | Ingredient 102 | Ingredient 103 | Ingredient 104 | Ingredient 105 | Ingredient 106 | Ingredient 107 | Ingredient 108 | Ingredient 109 | Ingredient 110 | Ingredient 111 | Ingredient 112 | Ingredient 113
Drop Down Product Code |  |  |  |  |  |  |  |  |  |  | Formulation | 28.22 | 1.333333333333333 | 5.2 | 3 | 0 | 2 | 0 | 0 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cells auto populate depending on what is selected in the  A2 dropdown. |  |  |  |  |  |  |  |  |  |  | Raw Material Cost Per Gram | 0.294796883254094 | 2 | 0.2265 | 0.0102 | 0 | 0.3 | 0 | 0 | 2e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Ingredient Name | Formulation | Raw Material
 |  |  |  |  |  |  |  |  |  | Trying to get the information above to populate for the ingredients that are used in the formulation or have a value above 0
 |  |  |  |  |  |  |  |  |  | The other option would be to just hide the colums with 0 value automatically based on color set in coditional formatting.