Vlookup vs Xlookup.xlsx

	A	B	C	D	E	F	G
1	Order No	Order Date	City	Account Manager	Order Priority	Product Name	Product Category
2	5071-1	2013-05-05	Dhaka	Afifa Siddika	Medium	Laser Neon Mac Format Diskettes, 10/Pack	Technology
3	5071-2	2013-05-05	Dhaka	Afifa Siddika	Medium	Steady Liquid Accent Highlighters	Office Supplies
4	5145-1	2013-06-29	Dhaka	Tabassum Khan	Low	Alto Memo Cubes	Office Supplies
5	5145-2	2013-06-29	Dhaka	Tabassum Khan	Low	Artisan Hi-Liter Smear-Safe Highlighters	Office Supplies
6	5160-1	2013-07-05	Chittagong	Sajid Khandakar	Not Specified	1726 Digital ADhakaering Machine	Technology
7	5160-2	2013-07-05	Chittagong	Sajid Khandakar	Not Specified	3Max Organizer Strips	Office Supplies
8	5168-1	2013-07-15	Dhaka	Kidwa Arif	Critical	Smiths Pen Style Liquid Stix; Assorted (yellow, pink, green, blue, orange), 5/Pack	Office Supplies
9	5168-2	2013-07-15	Dhaka	Kidwa Arif	Critical	Steady Liquid Accent Tank-Style Highlighters	Office Supplies
10	5195-1	2013-07-31	Dhaka	Ziaus Shams	Medium	Artisan Durable Binders	Office Supplies
11	5195-2	2013-07-31	Dhaka	Ziaus Shams	Medium	Beekin 105-Key Black Keyboard	Technology
12	5268-1	2013-10-11	Chittagong	Sabrin Radi	Not Specified	Artisan Binder Labels	Office Supplies
13	5268-2	2013-10-11	Chittagong	Sabrin Radi	Not Specified	Economy Rollaway Files	Office Supplies
14	5274-1	2013-10-13	Dhaka	Afifa Siddika	Critical	300 Series Non-Flip	Technology
15	5274-2	2013-10-13	Dhaka	Afifa Siddika	Critical	3Max Organizer Strips	Office Supplies
16	5335-1	2013-12-11	Chittagong	Sabrin Radi	Low	Artisan Printable Repositionable Plastic Tabs	Office Supplies
17	5335-2	2013-12-11	Chittagong	Sabrin Radi	Low	OIC Colored Binder Clips, Assorted Sizes	Office Supplies
18	5358-1	2014-01-04	Dhaka	Abu Tayeb Taki	Critical	Artisan Heavy-Duty EZD Binder With Locking Rings	Office Supplies
19	5358-2	2014-01-04	Dhaka	Abu Tayeb Taki	Critical	Desktop 3-Pocket Hot File	Office Supplies
20	5367-1	2014-01-10	Dhaka	Syed Fahim	Medium	3Max Organizer Strips	Office Supplies
21	5367-2	2014-01-10	Dhaka	Syed Fahim	Medium	Office Shears by Apex	Office Supplies
22	5402-1	2014-02-07	Chittagong	Sabrin Radi	Low	HFX LaserJet 3310 Copier	Technology
23	5402-2	2014-02-07	Chittagong	Sabrin Radi	Low	Unpadded Memo Slips	Office Supplies
24	5479-1	2014-05-06	Dhaka	Afifa Siddika	Not Specified	Artisan Poly Binder Pockets	Office Supplies
25	5479-2	2014-05-06	Dhaka	Afifa Siddika	Not Specified	Assorted Color Push Pins	Office Supplies
26	5539-1	2014-06-29	Dhaka	Nowshin Islam	Not Specified	Angle-D Binders with Locking Rings, Label Holders	Office Supplies
27	5539-2	2014-06-29	Dhaka	Nowshin Islam	Not Specified	Smiths Paper Clips	Office Supplies
28	5558-1	2014-07-18	Dhaka	Tabassum Khan	Low	Colored Push Pins	Office Supplies
29	5558-2	2014-07-18	Dhaka	Tabassum Khan	Low	Steady Colorific Eraseable Coloring Pencils, 12 Count	Office Supplies
30	5566-1	2014-07-26	Dhaka	Sunayna Illin	Low	HFX LaserJet 3310 Copier	Technology
31	5566-2	2014-07-26	Dhaka	Sunayna Illin	Low	Smiths Metal Binder Clips	Office Supplies
32	5599-1	2014-08-28	Chittagong	Sabrin Radi	High	Cando PC940 Copier	Technology
33	5599-2	2014-08-28	Chittagong	Sabrin Radi	High	EcoTones Memo Sheets	Office Supplies
34	5609-1	2014-09-07	Dhaka	Kidwa Arif	Not Specified	Smiths General Use 3-Ring Binders	Office Supplies
35	5609-2	2014-09-07	Dhaka	Kidwa Arif	Not Specified	Steady Liquid Accent Tank-Style Highlighters	Office Supplies
36	5621-1	2014-09-21	Chittagong	Sajid Khandakar	Medium	600 Series Non-Flip	Technology
37	5621-2	2014-09-21	Chittagong	Sajid Khandakar	Medium	Binder Clips by OIC	Office Supplies
38	5655-1	2014-10-17	Chittagong	Sajid Khandakar	Medium	Apex Straight Scissors	Office Supplies
39	5655-2	2014-10-17	Chittagong	Sajid Khandakar	Medium	EcoTones Memo Sheets	Office Supplies
40	5724-1	2014-12-27	Dhaka	Abu Tayeb Taki	High	Multi-Use Personal File Cart and Caster Set, Three Stacking Bins	Office Supplies
41	5724-2	2014-12-27	Dhaka	Abu Tayeb Taki	High	Smiths Bulldog Clip	Office Supplies
42	5762-1	2015-01-20	Dhaka	Abu Tayeb Taki	Not Specified	Artisan Hi-Liter EverBold Pen Style Fluorescent Highlighters, 4/Pack	Office Supplies
43	5762-2	2015-01-20	Dhaka	Abu Tayeb Taki	Not Specified	Smiths General Use 3-Ring Binders	Office Supplies
44	5768-1	2015-01-22	Dhaka	Tabassum Khan	Critical	1726 Digital ADhakaering Machine	Technology
45	5768-2	2015-01-22	Dhaka	Tabassum Khan	Critical	Artisan Flip-Chart Easel Binder, Black	Office Supplies
46	5768-2	2015-01-22	Dhaka	Tabassum Khan	Critical	Beekin 105-Key Black Keyboard	Technology
47	5804-1	2015-02-18	Chittagong	Sajid Khandakar	High	Artisan Durable Poly Binders	Office Supplies
48	5804-2	2015-02-18	Chittagong	Sajid Khandakar	High	Artisan Hi-Liter Pen Style Six-Color Fluorescent Set	Office Supplies
49	5869-1	2015-04-25	Chittagong	Sajid Khandakar	Critical	Bagged Rubber Bands	Office Supplies
50	5869-2	2015-04-25	Chittagong	Sajid Khandakar	Critical	DrawIt Pizazz Watercolor Pencils, 10-Color Set with Brush	Office Supplies
51	5887-1	2015-05-11	Dhaka	Afifa Siddika	Medium	Apex Box Cutter Scissors	Office Supplies
52	5887-2	2015-05-11	Dhaka	Afifa Siddika	Medium	Artisan Hanging File Binders	Office Supplies
53	5943-1	2015-06-25	Dhaka	Nowshin Islam	Medium	12 Colored Short Pencils	Office Supplies
54	5943-2	2015-06-25	Dhaka	Nowshin Islam	Medium	TechSavi Cordless Navigator Duo	Technology
55	5990-1	2015-07-25	Chittagong	Sabrin Radi	High	Adams "While You Were Out" Message Pads	Office Supplies
56	5990-2	2015-07-25	Chittagong	Sabrin Radi	High	Barrel Sharpener	Office Supplies
57	5997-1	2015-07-27	Chittagong	Sajid Khandakar	Low	Binder Clips by OIC	Office Supplies
58	5997-2	2015-07-27	Chittagong	Sajid Khandakar	Low	PastelOcean Color Pencil Set	Office Supplies
59	6014-1	2015-08-10	Dhaka	Abu Tayeb Taki	Not Specified	Alto 3-Hole Punch	Office Supplies
60	6014-2	2015-08-10	Dhaka	Abu Tayeb Taki	Not Specified	Apex Forged Steel Scissors with Black Enamel Handles	Office Supplies
61	6091-1	2015-10-15	Dhaka	Kidwa Arif	Low	Smiths Paper Clips	Office Supplies
62	6091-2	2015-10-15	Dhaka	Kidwa Arif	Low	Wirebound Message Book, 4 per Page	Office Supplies
63	6104-1	2015-11-01	Dhaka	Kidwa Arif	Low	DrawIt Pizazz Watercolor Pencils, 10-Color Set with Brush	Office Supplies
64	6104-2	2015-11-01	Dhaka	Kidwa Arif	Low	Steady Colorific Colored Pencils, 12/Box	Office Supplies
65	6143-1	2015-12-16	Dhaka	Afifa Siddika	Critical	Beekin 105-Key Black Keyboard	Technology
66	6143-2	2015-12-16	Dhaka	Afifa Siddika	Critical	Multi-Use Personal File Cart and Caster Set, Three Stacking Bins	Office Supplies
67	6159-1	2015-12-31	Dhaka	Sunayna Illin	High	Angle-D Binders with Locking Rings, Label Holders	Office Supplies
68	6159-2	2015-12-31	Dhaka	Sunayna Illin	Medium	Artisan 487 Labels	Office Supplies
69	6159-2	2015-12-31	Dhaka	Sunayna Illin	High	DrawIt Colored Pencils	Office Supplies
70	6197-1	2016-02-12	Chittagong	Sajid Khandakar	Critical	Lumi Crayons	Office Supplies
71	6197-2	2016-02-12	Chittagong	Sajid Khandakar	Critical	Pizazz Colored Pencils	Office Supplies
72	6266-1	2016-04-18	Dhaka	Syed Fahim	Medium	3Max Polarizing Task Lamp with Clamp Arm, Light Gray	Furniture
73	6266-2	2016-04-18	Dhaka	Syed Fahim	Medium	Binder Clips by OIC	Office Supplies
74	6278-1	2016-05-01	Dhaka	Kidwa Arif	Not Specified	Artisan Durable Binders	Office Supplies
75	6278-2	2016-05-01	Dhaka	Kidwa Arif	Not Specified	Beekin 6 Outlet Metallic Surge Strip	Office Supplies
76	6280-1	2016-05-02	Chittagong	Sabrin Radi	High	Aluminum Document Frame	Furniture
77	6280-2	2016-05-02	Chittagong	Sabrin Radi	High	Artisan Poly Binder Pockets	Office Supplies
78	6324-1	2016-06-14	Chittagong	Sajid Khandakar	Low	1726 Digital ADhakaering Machine	Technology
79	6325-1	2016-06-14	Dhaka	Tabassum Khan	High	Adesso Programmable 142-Key Keyboard	Technology
80	6325-2	2016-06-14	Dhaka	Tabassum Khan	High	Laser DVD-RAM discs	Technology
81	6328-1	2016-06-14	Chittagong	Sajid Khandakar	Low	OIC Thumb-Tacks	Office Supplies
82	6336-1	2016-06-20	Dhaka	Afifa Siddika	Medium	Pizazz Drawing Pencil Set	Office Supplies
83	6336-2	2016-06-20	Dhaka	Afifa Siddika	Medium	Smiths Metal Binder Clips	Office Supplies
84	6384-1	2016-08-24	Dhaka	Ziaus Shams	Low	HFX LaserJet 3310 Copier	Technology
85	6384-2	2016-08-24	Dhaka	Ziaus Shams	Low	PastelOcean Color Pencil Set	Office Supplies
86	6403-1	2016-09-18	Dhaka	Abu Tayeb Taki	Medium	Artisan Printable Repositionable Plastic Tabs	Office Supplies
87	6403-2	2016-09-18	Dhaka	Abu Tayeb Taki	Medium	Economy Rollaway Files	Office Supplies
88	6417-1	2016-09-26	Dhaka	Afifa Siddika	Medium	Artisan Flip-Chart Easel Binder, Black	Office Supplies
89	6417-2	2016-09-26	Dhaka	Afifa Siddika	Medium	TechSavi Cordless Access Keyboard	Technology
90	6457-1	2016-10-27	Chittagong	Sabrin Radi	Medium	UGen Ultra Cordless Optical Suite	Technology
91	6457-2	2016-10-27	Chittagong	Sabrin Radi	Medium	Unpadded Memo Slips	Office Supplies
92	6515-1	2016-12-08	Dhaka	Abtahi Iptesam	Low	Alto Parchment Paper, Assorted Colors	Office Supplies
93	6515-2	2016-12-08	Dhaka	Abtahi Iptesam	Low	OIC Thumb-Tacks	Office Supplies
94	5014-1	2013-02-11	Chittagong	Sabrin Radi	High	Artisan Heavy-Duty EZD Binder With Locking Rings	Office Supplies
95	5016-1	2013-02-11	Chittagong	Sajid Khandakar	High	DrawIt Pizazz Watercolor Pencils, 10-Color Set with Brush	Office Supplies
96	5018-1	2013-02-12	Dhaka	Ali Haider	Critical	Message Book, One Form per Page	Office Supplies
97	5019-1	2013-02-13	Chittagong	Sabrin Radi	High	Cando S750 Color Inkjet Printer	Technology
98	5020-1	2013-02-14	Dhaka	Abtahi Iptesam	Critical	Steady EarthWrite Recycled Pencils, Medium Soft, #2	Office Supplies
99	5022-1	2013-02-15	Dhaka	Ziaus Shams	Medium	Artisan Reinforcements for Hole-Punch Pages	Office Supplies
100	5023-1	2013-02-17	Chittagong	Sabrin Radi	Low	12 Colored Short Pencils	Office Supplies