Spreadsheet: 546740d1510174251-vlookup-between-sheets-to-give-different-code-dates-example-spreadsheet
Sheet: Product Specs

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53
 | Product | Spec 1 | Spec 2 | Spec 3 | Spec 4 | Spec 5 | Spec 6 | Spec 7 | Spec 8 | Spec 9 | Spec 10 | Spec 11 | Spec 12 | Spec 13 | Spec 14 | Spec 15 | Spec 16 | Target 1 | Target 2 | Target 3 | Target 4 | Target 5 | Target 6 | Target 7 | Target 8 | Target 9 | Target 10 | Target 11 | Target 12 | Target 13 | Target 14 | Target 15 | Target 16 | Range 1 | Range 2 | Range 3 | Range 4 | Range 5 | Range 6 | Range 7 | Range 8 | Range 9 | Range 10 | Range 11 | Range 12 | Range 13 | Range 14 | Range 15 | Range 16 | Extra Comments | Expiration (in days) | Columns Needed
11012546 | Tasty product | Overrun | [NAME] | Draw Temp | Weight | Weight | Weight | Weight | Stick Length | Volume | Volume | Correct Stick (Y/N) |  |  |  |  |  | 83% 9.59lbs |  |  | 67g | 67g | 67g | 67g |  | 104mL | 104mL | The green one |  |  |  |  |  | 195g | <45°F | 21-23°F | 66-68g | 66-68g | 66-68g | 66-68g | 48-54mm | 102-108mL | 102-108mL | Y/N |  |  |  |  |  |  | 365 | 11
12345678 | smelly product | Overrun | [NAME] | Draw Temp | Weight | Weight | Weight of IC + Stick | Stick Length | Volume of FP | Volume of FP |  |  |  |  |  |  |  | 0.82 |  |  | 78g | 78g | 78g |  | 118mL | 118mL |  |  |  |  |  |  |  |  | <45°F | 21-23°F | 77-79g | 77-79g | 77-79g | 48-55mm | 116-122mL | 116-122mL |  |  |  |  |  |  |  |  | 365 | 9
87654321 | Example 1 | Overrun | [NAME] | Draw Temp | Core Temp | Weight of Your Shoe | Weight of Right Sock | Weight of Left Glove | Weight of 100 Feathers | Weight of 2 pickles | Weight of FP | Weight of FP | Volume of FP | Volume of FP |  |  |  | 100% 9.24lbs |  |  | 0°F | 5g | 21g | 59g | 5g | 4g | 85g | 85g | 136mL | 136mL |  |  |  | 171g | <45°F | 21-23°F | ±5°F | 4-7g |  | 57-61g | 4-6g | 3-5g | 83-87g | 83-87g | 134-138mL | 134-138mL |  |  |  |  | 365 | 13
95135746 | Red Product | Overrun | [NAME] | Draw Temp | Core Temp | Weight | Weight of FP | Weight of FP | Weight of FP | Weight of IC Only | Height of FP | Height of FP | Height of FP |  |  |  |  | 79-81% |  |  | 0°F | 52g +8g for wrap | 52g +8g for wrap | 52g +8g for wrap | 52g +8g for wrap | 52g | ≥90%Filled | ≥90%Filled | ≥90%Filled |  |  |  |  | 194-196g | <45°F | 21-23°F | ±100°F | 59-62g | 59-62g | 59-62g | 59-62g | 52-54g | Y/N | Y/N | Y/N |  |  |  |  |  | 540 | 12
85796423 | Blue Product | Overrun | [NAME] | Draw Temp | Weight | Weight | Weight | Stick Length | Volume | Volume |  |  |  |  |  |  |  | 75% 9.58lbs |  |  | 68g | 68g | 68g |  | 101mL | 101mL |  |  |  |  |  |  |  | 204g | <45°F | 21-23°F | 67-69g | 67-69g | 67-69g | 48-55mm | 97-105mL | 97-105mL |  |  |  |  |  |  |  |  | 365 | 9
12365412 | Example 2 | Overrun | [NAME] | Draw Temp | Weight | Weight | Weight | Stick Length | Volume | Volume |  |  |  |  |  |  |  | 70% 9.24lbs |  |  | 76g | 76g | 76g |  | 114mL | 114mL |  |  |  |  |  |  |  | 202g | <45°F | 21-23°F | 75-77g | 75-77g | 75-77g | 48-52mm | 110-118mL | 110-118mL |  |  |  |  |  |  |  |  | 546 | 9