VLOOKUP_Function
Order Details
OrderDate Region Rep
Item
Units UnitCost
Total
Jones
Pencil
95
1.99
1/23/2019 Central
Kivell
Binder
50
19.99
189.05 Region
999.5 Rep
2/9/2019
2/26/2019
3/15/2019
4/1/2019
4/18/2019
Central
Central
W est
East
Central
Jardine
Gill
Sorvino
Jones
Andrews
Pencil
Pen
Pencil
Binder
Pencil
-
-
-
5/5/2019
5/22/2019
6/8/2019
6/25/2019
7/12/2019
7/29/2019
Central
W est
East
Central
East
East
Jardine
Thompson
Jones
Morgan
Howard
Parent
Pencil
Pencil
Binder
Pencil
Binder
Binder
-
-
-,619.19
Jones
Smith
Jones
Pencil
Desk
Pen Set
35
2
16
-
-
Morgan
Jones
Binder
Pen
28
64
8.99
8.99
-
1/6/2019 East
8/15/2019 East
9/1/2019 Central
9/18/2019 East
10/5/2019 Central
10/22/2019 East
Parent
Pen
15
19.99
299.85
11/25/2019 Central
12/12/2019 Central
11/8/2019 East
Kivell
Smith
Pen Set
Pencil
96
67
4.99
1.29
-
12/29/2019 East
1/15/2020 Central
Parent
Gill
Pen Set
Binder
74
46
-
1,-
2/1/2020 Central
2/18/2020 East
Smith
Jones
Binder
Binder
87
4
15
4.99
1,-
3/7/2020 W est
3/24/2020 Central
Sorvino
Jardine
Binder
Pen Set
7
50
-
-
4/10/2020 Central
4/27/2020 East
5/14/2020 Central
Andrews
Howard
Gill
Pencil
Pen
Pencil
66
96
53
-
-
5/31/2020
6/17/2020
7/4/2020
7/21/2020
8/7/2020
Gill
Kivell
Jones
Morgan
Kivell
Binder
Desk
Pen Set
Pen Set
Pen Set
-
-
-,005.90
Sorvino
Desk
3
275
825
Gill
Sorvino
Thompson
Andrews
Pencil
Pen
Binder
Pencil
-
-
-,-
11/17/2020 Central
Jardine
Binder
11
4.99
54.89
12/4/2020 Central
Jardine
Binder
94
19.99
1,879.06
12/21/2020 Central
Sub Total
Andrews
Binder
28
4.99
-
Central
Central
East
Central
Central
8/24/2020 W est
9/10/2020
9/27/2020
10/14/2020
10/31/2020
Central
W est
W est
Central
Item
Units
Unit Cost
Total
East
Jones
Binder
VLOOKUP
-