Product Product Position Formula Text
Chai Walnuts 7 =_xlfn.xmatch(C2,$A$2:$A$12)
Syrup Wal? 7 =_xlfn.xmatch(C3,$A$2:$A$12,1)
Cajun Seasoning *Oil 4 =_xlfn.xmatch(C4,$A$2:$A$12,2)
Olive Oil *Sauce 6 =_xlfn.xmatch(C5,$A$2:$A$12,2)
Dried Pears *Sauce 11 =_xlfn.xmatch(C6,$A$2:$A$12,2,-1)
Curry Sauce
Walnuts
Fruit Cocktail
Chocolate Biscuits Mix
Marmalade
Tomato Sauce
Product Position
Walnuts 8
Product Code Product Name Price
NWTB-1 Chai 18.00
NWTCO-3 Syrup 10.00
NWTCO-4 Cajun Seasoning 22.00
NWTO-5 Olive Oil 21.35
NWTJP-6 Boysenberry Spread 25.00
NWTDFN-7 Dried Pears 30.00
NWTS-8 Curry Sauce 40.00
NWTDFN-14 Walnuts 23.25
NWTCFV-17 Fruit Cocktail 39.00
NWTBGM-19 Chocolate Biscuits Mix 9.20
Sales Rep Quarter Sales
1 4 $22,596
Sales Rep Q1 Q2 Q3 Q4
Penny $17,526 $23,972 $61,066 $22,596
Leslie $49,405 $36,646 $21,899 $62,629
Sally $78,658 $16,529 $14,976 $68,184
Shaun $80,176 $84,918 $66,561 $65,326
Julie $86,988 $29,692 $30,197 $80,960
Velma $94,514 $13,333 $78,000 $59,718
Ian $23,183 $21,547 $40,408 $57,767
Cassandra $70,597 $19,615 $54,664 $68,175
Mark $16,832 $91,907 $19,062 $23,167
Kathy $45,446 $14,638 $52,312 $92,069
Renee $34,583 $78,213 $21,295 $26,964
Judith $18,689 $91,081 $66,795 $96,860
Sales Rep Quarter Sales
Shaun Q3 #NAME?
Sales Rep Q1 Q2 Q3 Q4
Penny $17,526 $23,972 $61,066 $22,596
Leslie $49,405 $36,646 $21,899 $62,629
Sally $78,658 $16,529 $14,976 $68,184
Shaun $80,176 $84,918 $66,561 $65,326
Julie $86,988 $29,692 $30,197 $80,960
Velma $94,514 $13,333 $78,000 $59,718
Ian $23,183 $21,547 $40,408 $57,767
Cassandra $70,597 $19,615 $54,664 $68,175
Mark $16,832 $91,907 $19,062 $23,167
Kathy $45,446 $14,638 $52,312 $92,069
Renee $34,583 $78,213 $21,295 $26,964
Judith $18,689 $91,081 $66,795 $96,860