Vlookup and Match problem

[sandy666]

=VLOOKUP(F$26,{"Part",13,25,37,48,73,101,145,201,2 89,600,750,1009;"DMG1",4.1,2.85,2.85,1.9,1.55,1.35 ,1.25,0.95,0.85,0.75,0.75,0.65;"DMG2",5.3,3.75,2.8 5,2.65,2.1,1.8,1.65,1.25,1.1,0.9,0.9,0.75;"DMG3",7 .05,4.6,4.6,3.45,2.65,2.15,1.9,1.5,1.25,1.05,1.05, 0.9;"DMG4",8.05,5.95,5.95,4.1,3.2,2.45,2.3,1.75,1. 4,1.2,1.2,1;"FE1",2.25,2.25,1.6,1.6,1.4,1.4,1.2,1. 2,1,0.95,0.95,0.9;"FE2",2.35,2.35,1.8,1.8,1.55,1.5 5,1.4,1.4,1.05,1,1,0.95;"FE3",2.55,2.55,2,2,1.7,1. 7,1.6,1.6,1.1,1.05,1.05,1;"FE4",2.75,2.75,2.2,2.2, 1.85,1.85,1.75,1.75,1.15,1.1,1.1,1.05;"HTECH1",2.8 8,1.77,1.77,1.77,1.14,1.14,0.91,0.91,0.78,0.66,0.6 ,0.55;"HTECH2",4.6,2.25,2.25,2.25,1.43,1.43,1.28,1 .28,1.02,0.84,0.76,0.69;"HTECH3",6.66,2.74,2.74,2. 21,1.71,1.62,1.62,1.62,1.27,1.02,0.93,0.84;"HTECH4 ",8.05,3.11,3.11,2.5,2.04,2.04,1.98,1.98,1.51,1.2, 1.09,0.98},6)

where is DMG1 on index = 6 ?

I see DMG1 on index = 14

with formula =VLOOKUP(F$26,bk,MATCH($B$24,bkt,1)+1,0) value $1.55 is returned and so on

OP just forgot comma on the end or define last argument 0, VLOOKUP(F$26,bk,MATCH($B$24,bkt,1)+1,) so he need to learn how to use VLOOKUP function
VLOOKUP require all arguments, even if last argument is omitted there should be defined place for it after last comma

I suggest to use INDEX / MATCH instead of VLOOKUP

			Decorating Cost Each			Screen Costs Each			Cost Each Total			Total Cost For Quantity			Sell price each @ objective
Size	QTY	Apparel Cost EA	HTECH	FE	DMG	HTECH	FE	DMG	HTECH	FE	DMG	HTECH	FE	DMG	HTECH	FE	DMG
XS	10	$ 10.00	$ 1.14	$ 1.40	$ 1.55	$ 0.03	$ 0.35	$ -	$ 11.17	$ 11.75	$ 11.55	$ 111.71	$ 117.50	$ 115.50	$ 18.02	$ 18.95	$ 18.63
S	10	$ 10.00	$ 1.14	$ 1.40	$ 1.55	$ 0.03	$ 0.35	$ -	$ 11.17	$ 11.75	$ 11.55	$ 111.71	$ 117.50	$ 115.50	$ 18.02	$ 18.95	$ 18.63
M	10	$ 10.00	$ 1.14	$ 1.40	$ 1.55	$ 0.03	$ 0.35	$ -	$ 11.17	$ 11.75	$ 11.55	$ 111.71	$ 117.50	$ 115.50	$ 18.02	$ 18.95	$ 18.63
L	10	$ 10.00	$ 1.14	$ 1.40	$ 1.55	$ 0.03	$ 0.35	$ -	$ 11.17	$ 11.75	$ 11.55	$ 111.71	$ 117.50	$ 115.50	$ 18.02	$ 18.95	$ 18.63
XL	10	$ 10.00	$ 1.14	$ 1.40	$ 1.55	$ 0.03	$ 0.35	$ -	$ 11.17	$ 11.75	$ 11.55	$ 111.71	$ 117.50	$ 115.50	$ 18.02	$ 18.95	$ 18.63
2XL	10	$ 11.00	$ 1.14	$ 1.40	$ 1.55	$ 0.03	$ 0.35	$ -	$ 12.17	$ 12.75	$ 12.55	$ 121.71	$ 127.50	$ 125.50	$ 19.63	$ 20.56	$ 20.24
3XL	10	$ 12.00	$ 1.14	$ 1.40	$ 1.55	$ 0.03	$ 0.35	$ -	$ 13.17	$ 13.75	$ 13.55	$ 131.71	$ 137.50	$ 135.50	$ 21.24	$ 22.18	$ 21.85
4XL	10	$ 13.00	$ 1.14	$ 1.40	$ 1.55	$ 0.03	$ 0.35	$ -	$ 14.17	$ 14.75	$ 14.55	$ 141.71	$ 147.50	$ 145.50	$ 22.86	$ 23.79	$ 23.47
5XL	0	$ 14.00	$ 1.14	$ 1.40	$ 1.55	$ 0.03	$ 0.35	$ -	$ 15.17	$ 15.75	$ 15.55	$ -	$ -	$ -	$ 24.47	$ 25.40	$ 25.08
6XL	0	$ 17.00	$ 1.14	$ 1.40	$ 1.55	$ 0.03	$ 0.03	$ -	$ 18.17	$ 18.43	$ 18.55	$ -	$ -	$ -	$ 29.31	$ 29.73	$ 29.92
	80											$ 953.70	$ 1,000.00	$ 984.00