Spreadsheet: 163904d1340536576-lookup-question-tricky-sample-file
Sheet: Main sheet

ENTITY - 100 ML - DE BEERS -
 |  |  | FINISH PRODUCT |  | BOTTLE |  |  | CAPS |  |  |  |  | UNIT CARTON |  |  |  | CONCENTRATE
Sr.No. | VARIANT NAME |  | FG STOCK | To Produce | STOCK | ON ORDER | Stock after Production & On Order |  | [NAME] | STOCK | ON ORDER | Stock after Production & On Order |  | STOCK | ON ORDER | Stock after Production & On Order |  | STOCK | ON ORDER | Stock after Production & On Order | SUPPLIER
1 | WAY | EN/WAY/M/100/EDT | 385 | 1271 |  |  |  | CAP/EC/DE/BLCK/100/EN/M | BLACK | 59375 | 0 | 54247 | UCN/ut/DE/WAY/100/EN/M | 87 | 10000 | 8816 | CON/ES/PINO/PLAY/GVENCHY/M | 0 | 25 | 21.701755 | Essence
2 | JUST MAN | EN/JTM/M/100/EDT | 2382 | 0 |  |  |  | CAP/EC/DE/BRWN/100/EN/M | BROWN | 29133 | 0 | 29133 | UCN/UT/DE/JTM/100/EN/M | 10812 | 0 | 10812 | CON/ES/CAMA/CH/CHRRA/M | 10.15 | 10 | 20.15 | Essence
3 | DEEPLY BLACK | EN/DLB/M/100/EDT | 1125 | 963 |  |  |  | CAP/EC/DE/BLUE/100/EN/M | BLUE | 14691 | 0 | 13404 | UCN/UT/DE/DLB/100/EN/M | 8549 | 0 | 7586 | CON/ES/DJAN/BLCK/DNHIL/M | 24 | 0 | 21.501015 | Essence
4 | ONLY FOR HIM | EN/OFH/M/100/EDT | 1260 | 324 |  |  |  |  | BLUE |  |  |  | UCN/UT/DE/OFH/100/EN/M | 3968 | 5000 | 8644 | CON/PB/DILA/OTB/DSEL/M | 13 | 0 | 12.15922 | SFA
5 | GALLANT | EN/GAL/M/100/EDT | 23 | 1441 |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/GAL/100/EN/M | 5085 | 0 | 3644 | CON/PB/GIUL/GUCCI2/GUCI/M | 9.5 | 0 | 5.760605 | SFA
6 | MIDNIGHT | EN/MID/M/100/EDT | 959 | 121 |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/MID/100/EN/M | 15587 | 0 | 15466 | CON/AR/DUSK/LANUIT/YSL/M | 10 | 0 | 9.686005 | [NAME]
7 | ALTITUDE EFFECT | EN/AEF/M/100/EDT | 2194 | 0 |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/AEF/100/EN/M | 9208 | 0 | 9208 | CON/GF/67967/ATEXT/GOARM/M | 11 | 0 | 11 | Quintessence
8 | E'FRANCKY | EN/EFC/M/100/EDT | 1665 | 0 |  |  |  |  | BLUE |  |  |  | UCN/ut/DE/EFC/100/EN/M | 11022 | 0 | 11022 | CON/AR/FRIN/EAUFRCH/VRSCE/M | 6 | 10 | 16 | [NAME]
9 | TUSK | EN/TSK/M/100/EDT | 6933 | 2295 |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/TSK/100/EN/M | 4946 | 0 | 2651 | CON/GR/30-6620/TUSC/ARAMIS/M | 14.5 | 0 | 8.544475 | Grasse French
10 | PARODY POUR HOMME | EN/PRD/M/100/EDT | 2691 | 0 |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/PRD/100/EN/M | 8301 | 0 | 8301 | CON/GR/30-4920/PARO/PRABN/M | 6.6 | 0 | 6.6 | Grasse French
11 | JUMP | EN/JMP/M/100/EDT | 2053 | 0 |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/JMP/100/EN/M | 9106 | 0 | 9106 | CON/AR/JOEL/JOOP/JOOP/M | 16 | 0 | 16 | [NAME]
12 | 9HUNDRED | EN/9HD/M/100/EDT | 687 | 0 |  |  |  |  | BROWN |  |  |  | UCN/UT/DE/9HD/100/EN/M | 18491 | 0 | 18491 | CON/AR/ARIS/900/ARAMIS/M | 17 | 0 | 17 | [NAME]
 | Total |  | 22357 | 6415 |  |  |  |  |  | 103199 | 0 | 96784 | 0 | 105162 | 15000 | 113747 | 0 | 137.75 | 45 | 166.103075
 |  | BOT/PR/DE/CL/100/EC/M | Plain |  | 96731 | 16 | 90332
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  | UCN
 |  |  |  |  |  |  |  | Caps Code | Color | Stock | UCN Stcok | Difference | Code | Stock | Need to Order | Total
 |  |  |  |  |  |  |  | CAP/EC/DE/BLCK/100/EN/M | BLACK |  |  |  | UCN/ut/DE/WAY/100/EN/M
 |  |  |  |  |  |  |  | CAP/EC/DE/BRWN/100/EN/M | BROWN |  |  |  | UCN/UT/DE/JTM/100/EN/M
 |  |  |  |  |  |  |  | CAP/EC/DE/BLUE/100/EN/M | BLUE |  |  |  | UCN/UT/DE/DLB/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/OFH/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/GAL/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/MID/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/AEF/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/DE/EFC/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/TSK/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/PRD/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/JMP/100/EN/M
 | Customer Orders |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/9HD/100/EN/M
 | VARIANT | CODE | CUSTOMER0 | CUSTOMER1 | CUSTOMER2 | CUSTOMER3 | Total
 | WAY | EN/WAY/M/100/EDT
 | JUST MAN | EN/JTM/M/100/EDT
 | DEEPLY BLACK | EN/DLB/M/100/EDT
 | ONLY FOR HIM | EN/OFH/M/100/EDT
 | GALLANT | EN/GAL/M/100/EDT
 | MIDNIGHT | EN/MID/M/100/EDT
 | ALTITUDE EFFECT | EN/AEF/M/100/EDT
 | E'FRANCKY | EN/EFC/M/100/EDT
 | TUSK | EN/TSK/M/100/EDT
 | PARODY POUR HOMME | EN/PRD/M/100/EDT
 | JUMP | EN/JMP/M/100/EDT
 | 9HUNDRED | EN/9HD/M/100/EDT