Test - Tiered Pricing Lookup

	A	D	E	F	G	H	I	J	K	L	Q	V	W	X	Y	Z	AB	AF	AM	AT	AU	AV	BQ	BR	BY	BZ	CI	CJ	CK	CL	CM	CN	CQ	CV	CZ	DD	DH	DI	DJ	DK	DL	DM	DN	DO	DP	DQ
1	SKU	Product Name - Full	Product Format	6	CAT	Subcategory Code	Category Code	10	SPEC	NAMING	AVAIL	PACK	Unit Size	Per-SU	Per-CS	Conversion	TYPE	SUPP	COST	Applied Cost	47	ORD	69	COMP	77	PRICE	87	TIERS	Price Line Lookup	Price Line Lookup	Have to drag down formula currently <<<<<	MIN	OVERRIDE	BCL	FAM	SPEC	•LEVELS	① LV1	Edit...	Edit...	Edit...	Edit...	NEW	Edit...	GP1%	F

2	35228618	Ainyx - Black Cherry	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.93									PL_Code:4	PL_Code:4
3	36833202	Ainyx - Crisp Apple	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.93									PL_Code:4	PL_Code:4
4	37668937	Ainyx - Harvest Pear	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.94									PL_Code:4	PL_Code:4
5	38302792	Ainyx - Ogopogo Sampler	12 x 355 ml			1010	10						0.355	12.00	24.00	2.00				20.29									PL_Code:6	PL_Code:6
6	39388188	Ainyx - Peach	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.91									PL_Code:4	PL_Code:4
7	48381899	Brightdog - Rose	4 x 355 ml			1010	10						0.355	4.00	24.00	6.00				12.99									PL_Code:3	PL_Code:3
8	4917383	Brightdog - Sesh	4 x 355 ml			1010	10						0.355	4.00	24.00	6.00				11.99									PL_Code:3	PL_Code:3
9	50393908	Brightdog - Stone Fruit	4 x 355 ml			1010	10						0.355	4.00	24.00	6.00				12.99									PL_Code:3	PL_Code:3
10	45622282	Chatterpoint - Original Dry	4 x 500 ml			1010	10						0.500	4.00	24.00	6.00				10.95									PL_Code:3	PL_Code:3
11	46106083	Chatterpoint - Original Dry	8 x 440 ml			1010	10						0.440	8.00	24.00	3.00				18.03									PL_Code:5	PL_Code:5
12	4781136	Chatterpoint - Rose Apple	4 x 440 ml			1010	10						0.440	4.00	24.00	6.00				10.69									PL_Code:3	PL_Code:3
13	6633163	Cogibox - Apple Lime	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.83									PL_Code:4	PL_Code:4
14	1933171	Cogibox - Extra Apple	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.83									PL_Code:4	PL_Code:4
15	2033176	Cogibox - Peach	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.83									PL_Code:4	PL_Code:4
16	2133168	Cogibox - Pear	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.83									PL_Code:4	PL_Code:4
17	2228203	Cogibox - Raspberry	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.83									PL_Code:4	PL_Code:4
18	25178730	Cogibox - Rose	6 x 330 ml			1010	10						0.330	6.00	24.00	4.00				10.71									PL_Code:4	PL_Code:4
19	40386320	Dabshots - Strawberry Lime	4 x 330 ml			1010	10						0.330	4.00	24.00	6.00				10.24									PL_Code:3	PL_Code:3
20	21338	Devcast - Crisp Apple	4 x 473 ml			1010	10						0.473	4.00	24.00	6.00				9.60									PL_Code:3	PL_Code:3
21	3879039	Devcast - Crisp Apple	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.61										PL_Code:4
22	41112893	Devshare - Apple	4 x 473 ml			1010	10						0.473	4.00	24.00	6.00				10.86										PL_Code:3
23	4277387	Devshare - Blackberry	4 x 473 ml			1010	10						0.473	4.00	24.00	6.00				10.87										PL_Code:3
24	43102733	Devshare - Pear	4 x 473 ml			1010	10						0.473	4.00	24.00	6.00				10.86										PL_Code:3
25	44102737	Devshare - Rhubarb	4 x 473 ml			1010	10						0.473	4.00	24.00	6.00				10.86										PL_Code:3
26	17187099	Livetube - Crisp Apple	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.07										PL_Code:4
27	33689823	Meevee - Original	4 x 500 ml			1010	10						0.500	4.00	24.00	6.00				11.40										PL_Code:3
28	DEL#1010	Ozu - Deleted item from Cider	DNA			1010	10						DNA	1.00	1.00	1.00				0.00
29	ERROR#REFRESH	Ozu - Refresh Item Received In Error	DNA			1010	10						DNA	1.00	1.00	1.00				19.47
30	28168773	Quamba - Dry Cider	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.71										PL_Code:4
31	29777631	Quamba - Ginger Apple	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.71										PL_Code:4
32	30870113	Quamba - Orchard Sampler	12 x 355 ml			1010	10						0.355	12.00	24.00	2.00				20.32										PL_Code:6
33	31793337	Quamba - Pear & Apple	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.70										PL_Code:4
34	3289921	Quamba - Rhubarb	6 x 355 ml			1010	10						0.355	6.00	24.00	4.00				10.69										PL_Code:4
35	34116386	Topicshots - BC Cider	4 x 473 ml			1010	10						0.473	4.00	24.00	6.00				11.08										PL_Code:3
36	1632382	Voonder - Broken Ladder Apples & Hops	4 x 473 ml			1010	10						0.473	4.00	24.00	6.00				10.56										PL_Code:3
37	85687608	Aibox - Lynchburg Lemonade	6 x 290 ml			1020	15						0.290	6.00	24.00	4.00				11.40										PL_Code:10
38	86667790	Aibox - Watermelon Punch	6 x 290 ml			1020	15						0.290	6.00	24.00	4.00				11.57										PL_Code:10
39	87393987	Avaveo - Grapefruit Hard Seltzer	4 x 355 ml			1020	15						0.355	4.00	24.00	6.00				11.65										PL_Code:9
40	85312381	Blognation - Adventure Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				23.98										PL_Code:12
41	86112879	Blognation - Discovery Pack	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				12.42										PL_Code:10
42	87333198	Blognation - Expedition Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				21.53										PL_Code:12
43	88383013	Blognation - Explorer Pack	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				12.42										PL_Code:10
44	8968778	Blognation - Grapefruit Rosemary	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				12.39										PL_Code:10
45	91388306	Blognation - Nailed It Gin Cocktail	4 x 355 ml			1020	15						0.355	4.00	24.00	6.00				8.92										PL_Code:9
46	91388769	Blognation - Peach Elderflower Gin	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				12.41										PL_Code:10
47	9268781	Blognation - Pear Rhubarb	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				12.40										PL_Code:10
48	5787381	Brainlounge - Mixer Pack	12 x 355 ml			1020	15						0.355	12.00	12.00	1.00				20.26										PL_Code:12
49	54323018	Brightbean - Iced Tea	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				10.60										PL_Code:10
50	53336828	Brightbean - Iced Tea	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				20.43										PL_Code:12
51	6116820	Camido - Hard Iced Tea Peach	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				10.23										PL_Code:10
52	9571627	Camido - Original	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				10.83										PL_Code:10
53	8183283	Camido - Original Hard Iced Tea	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				10.24										PL_Code:10
54	7180888	Camido - Original Hard Iced Tea	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				17.55										PL_Code:12
55	9181106	Camido - Party Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				17.58										PL_Code:12
56	10181098	Camido - Raspberry Iced Tea	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				9.93										PL_Code:10
57	96106363	Camido - Strawberry	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				10.85										PL_Code:10
58	97106360	Camido - Variety Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				21.62										PL_Code:12
59	67102619	Cogibox - Vodka Soda Variety Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				18.96										PL_Code:12
60	79113127	Cogilith - Hard Rootbeer	4 x 473 ml			1020	15						0.473	4.00	24.00	24.00				11.00										PL_Code:9
61	69266200	Devpulse - Party Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				21.21										PL_Code:12
62	49330681	Edgeclub - Hard Iced Tea Orginal 12 pack	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				20.24										PL_Code:12
63	5670862	Eimbee - Black Cherry Lemonade	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.09										PL_Code:10
64	6339833	Eimbee - Black Cherry Lemonade	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.09										PL_Code:10
65	779200	Eimbee - Blue Freeze	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				10.62										PL_Code:10
66	8300338	Eimbee - Hard Iced Tea Mixer	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				20.26										PL_Code:12
67	927907	Eimbee - Hard Peach Fuzz	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.21										PL_Code:10
68	10373866	Eimbee - Lemonade	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.63										PL_Code:10
69	11339828	Eimbee - Lemonade	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				10.11										PL_Code:10
70	13339836	Eimbee - Lemonade Mixer Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				22.30										PL_Code:12
71	1230301	Eimbee - Lemonade Variety Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				22.78										PL_Code:12
72	14177138	Eimbee - Lime	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.64										PL_Code:10
73	15339839	Eimbee - Lime	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.09										PL_Code:10
74	82399933	Eimbee - Orange Cream	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.64										PL_Code:10
75	19300289	Eimbee - Red Freeze	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.62										PL_Code:10
76	20327973	Eimbee - Sour Watermelon	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.23										PL_Code:10
77	82319338	Innotype - Spiked Variety Pack	12 x 341 ml			1020	15						0.341	12.00	12.00	1.00				21.97										PL_Code:12
78	9866189	Jaxnation - Apero Spritz	4 x 355 ml			1020	15						0.355	4.00	24.00	6.00				8.90										PL_Code:9
79	157699	Jazzy - Black Cherry	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.64										PL_Code:10
80	17383731	Jazzy - Blackberry	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.64										PL_Code:10
81	18383713	Jazzy - Citrus Surf Yuzu Smash	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				12.02										PL_Code:10
82	17708	Jazzy - Grapefruit	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.64										PL_Code:10
83	21377180	Jazzy - Iced Tea Mixer	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				23.54										PL_Code:12
84	227696	Jazzy - Lime	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.64										PL_Code:10
85	237702	Jazzy - Mango	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.64										PL_Code:10
86	24812086	Jazzy - Pineapple	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.64										PL_Code:10
87	2589890	Jazzy - Raspberry	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				11.63										PL_Code:10
88	16302378	Jazzy - Strawberry	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				12.62										PL_Code:10
89	26383708	Jazzy - Surf Variety	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				23.58										PL_Code:12
90	27333128	Jazzy - Surge Mixer	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				24.35										PL_Code:12
91	17339398	Jazzy - Tequila Smash - Variety Pack Can	8 x 355 ml			1020	15						0.355	8.00	24.00	3.00				17.04										PL_Code:11
92	28371373	Jazzy - V2 Mixer Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				21.30										PL_Code:12
93	167711	Jazzy - Variety Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				22.80										PL_Code:12
94	18339801	Jazzy - Vodka Smash -Variety Pack Can	8 x 355 ml			1020	15						0.355	8.00	24.00	3.00				15.49										PL_Code:11
95	3089887	Jazzy - Watermelon	6 x 355 ml			1020	15						0.355	6.00	24.00	4.00				10.14										PL_Code:10
96	3527836	Kamba - Mixer	8 x 473 ml			1020	15						0.473	8.00	24.00	3.00				15.40										PL_Code:11
97	5080383	Kare - 7 Vodka Soda Mixed Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	1.00				23.58										PL_Code:12
98	51338818	Kare - Tropical Mixer	12 x 355 ml			1020	15						0.355	12.00	24.00	2.00				23.59										PL_Code:12
99	52161879	Kare - Vodka Mixed Pack	12 x 355 ml			1020	15						0.355	12.00	24.00	1.00				23.56										PL_Code:12
100	99399827	Lajo - Pineapple Bay Breeze	4 x 355 ml			1020	15						0.355	4.00	24.00	6.00				8.45										PL_Code:9