Spreadsheet: 105057d1302537866-how-to-pull-a-value-x-amount-of-rows-above-the-lookup-value-book1
Sheet: Sheet2

 | active | active |  |  | active | active | active | active | active | active | active |  |  |  |  |  |  |  |  | active | active | active | active | active | active | active | active | active | active | active | active | active | nonactive | nonactive | active | active | active | active | active | active | active | active
 | liq | liq |  |  | liq | liq | liq | liq | liq | liq | liq |  |  |  |  |  |  |  |  | cap | pow | pow | pow | pow | pow | cap | cap | cap | pow | pow | pow | pow |  |  | Wax2 | Wax2 | Wax2 | Wax2 | Wax5 | Wax5 | Wax5 | Wax5
Check List | BL | CB | BM | IB | AB | BR | FP | G | GA | O | WM | CBB | CBB | CBB | CBB | CBB | CBB | CBB | CBB | PRO | PRO | PRO | PRO | PRO | PRO | MILK | MILK | PRO | MILK | MILK | MILK | MILK | MILK | MILK | MILK | MILK | MILK | MILK | MILK | MILK | MILK | MILK
 | Product 1a | Product 1b | Product 2a | Product 2b | Product 3a | Product 3b | Product 3c | Product 3d | Product 3e | Product 3f | Product 3f | NW42AB(CBB) | NW42BR(CBB) | NW42FP(CBB) | NW42G(CBB) | NW42GA(CBB) | NW42O(CBB) | NW42WTR(CBB) | Total for materials needed for all flavors | ALC | BNXP/BL | BNXP/CB | Creanox/FP | Creanox/PL | TR | 6hrCaf | BCAA120 | BCAA240 | Gainer/Choc | Gainer/Sban | Gainer/Vcinn | Gainer/Vcream | 10#Choc | 10#Van | 2#Wax/BlkCh | 2#Wax/FP | 2#Wax/G | 2#Wax/Nat | 5#Wax/BlkCh | 5#Wax/FP | 5#Wax/G | 5#Wax/Nat
Qty Ordered | 2000 | 2000 | 1000 | 1000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Materials Needed  for Order
Packaging
Label/Sleeve | 24000 | 24000 | 12000 | 12000 | 24000 | 24000 | 24000 | 24000 | 24000 | 24000 | 24000 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Display | 2000 | 2000 | 1000 | 1000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Master Case | 250 | 250 | 125 | 125 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Vial | 24000 | 24000 | 12000 | 12000 | 24000 | 24000 | 24000 | 24000 | 24000 | 24000 | 24000 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | 24000 | 24000 | 12000 | 12000 | 24000 | 24000 | 24000 | 24000 | 24000 | 24000 | 24000 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Raws (converted to lbs)
[NAME] |  |  | 191763.79071 | 191763.79071 | 1070743.656 | 1070743.656 | 1070743.656 | 1070743.656 | 1070743.656 | 1070743.656 | 1070743.656 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Protein Blend |  |  | 2884.553396437499 | 2884.553396437499 | 16155.648 | 16155.648 | 16155.648 | 16155.648 | 16155.648 | 16155.648 | 16155.648 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Flavor | 4046.255999999999 | 2165.328 | 3775.946475 | 4490.679200625 | 5394.216 | 5933.64 | 5933.64 | 10249.008 | 8900.448 | 2831.952 | 5191.92 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Sweetener | 4447.008000000001 | 4421.136 | 1651.9765828125 | 1708.6157799375 | 3395.664 | 3371.376 | 3371.376 | 3263.496 | 3139.44 | 3209.544 | 3128.64 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Functional Blend | 147385.296 | 147385.296 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
VM1 |  |  | 1022.202652875 | 1022.202652875
VM2 |  |  | 17718.6288339375 | 17718.6288339375
M |  |  | 40052.00368124999 | 40052.00368124999
CC |  |  | 3432.065635312499 | 3432.065635312499
MC |  |  | 2049.799515 | 2049.799515
Material Codes
Packaging
Label/Sleeve | B307 | B308 | F407 | F408 | N224 | N225 | N226 | N227 | N228 | N229 | N230 | CBB:L-42AB | CBB:L-42BR | CBB:L-42FP | CBB:[NAME] | CBB:L-42GA | CBB:L-42O | CBB:L-42WTR | CBB:L-42WTR | PRO:L-ALC | PRO:L-BNX/BL | PRO:L-BNX/CB | PRO:L-CNX/FP | PRO:L-CNX/PL | PRO:L-TR | MILK:L-6HRCAF | MILK:L-BCAA120 | MILK:L-BCAA240 | MILK:L-GAIN/CHOC | MILK:L-GAIN/STBA | MILK:L-GAIN/VCINN | MILK:L-GAIN/VCREAM | MILK:L-10#CHOC | MILK:L-10#VAN | MILK:L-2#WAX/BCH | MILK:L-2#WAX/FP | MILK:[NAME]/G | MILK:L-2#WAX/NAT | MILK:L-5#WAX/BCH | MILK:L-5#WAX/FP | MILK:[NAME]/G | MILK:L-5#WAX/NAT
Display | B305 | B306 | F405 | F406 | N215 | N216 | N217 | N218 | N219 | N220 | N221 | CBB:[NAME] | CBB:B-42BR | CBB:B-42FP | CBB:[NAME] | CBB:B-42GA | CBB:B-42O | CBB:B-42WTR | CBB:B-42WTR
Master Case | A103 | A103 | A103 | A103 | A103 | A103 | A103 | A103 | A103 | A103 | A103 | CBB:B-Master | CBB:B-Master | CBB:B-Master | CBB:B-Master | CBB:B-Master | CBB:B-Master | CBB:B-Master | CBB:B-Master
Vial | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | CBB:VIAL | CBB:VIAL | CBB:VIAL | CBB:VIAL | CBB:VIAL | CBB:VIAL | CBB:VIAL | CBB:VIAL
[NAME] | A102 | A102 | A102 | A102 | A102 | A102 | A102 | A102 | A102 | A102 | A102 | CBB:CAP | CBB:CAP | CBB:CAP | CBB:CAP | CBB:CAP | CBB:CAP | CBB:CAP | CBB:CAP
Raws
[NAME] |  |  | A104 | A104 | A104 | A104 | A104 | A104 | A104 | A104 | A104 | CBB:658 | CBB:658 | CBB:658 | CBB:658 | CBB:658 | CBB:658 | CBB:658 | CBB:658
Protein Blend |  |  | A105 | A105 | A105 | A105 | A105 | A105 | A105 | A105 | A105 | CBB:672 | CBB:672 | CBB:672 | CBB:672 | CBB:672 | CBB:672 | CBB:672 | CBB:672
Flavor | B301 | B303 | F401 | F403 | N201 | N203 | N205 | N207 | N209 | N211 | N213 | CBB:673/AB | CBB:673/BR | CBB:673/FP | CBB:673/G | CBB:673/GA | [NAME]/O | CBB:673/WTR | CBB:673/WTR
Sweetener | B302 | B304 | F402 | F404 | N202 | N204 | N206 | N208 | N210 | N212 | N214 | CBB:674/AB | CBB:674/BR | CBB:674/FP | CBB:674/G | CBB:674/GA | CBB:674/O | CBB:674/WTR | CBB:674/WTR
Functional Blend | A106 | A106
VM1 |  |  | A107 | A107
VM2 |  |  | A108 | A108
M |  |  | A109 | A109
CC |  |  | A110 | A110
MC |  |  | A111 | A111
 | 453.5924277 | grams per lb