Simple Case D1.xlsx

	A	B	C	D	E	F	G	I	J	K
1	Sr.No	Region	Rep	Item	Units Sold	Unit Cost	Total
2	1	Central	Smith	Desk	2	125.00	250.00
3	2	Central	Kivell	Chair	5	125.00	625.00
4	3	Central	Gill	Pencil	7	1.29	9.03
5	4	Central	Jardine	Binder	11	4.99	54.89
6	5	Central	Andrews	Color Pen	14	1.29	18.06
7	6	Central	Gill	Pen	27	19.99	539.73	Lookup Value	Desk
8	7	Central	Morgan	Sticky Notes	28	8.99	251.72	Units Sold	2	XLOOKUP(J7,D2:D21,E2:E21)
9	8	Central	Andrews	Glue	28	4.99	139.72			XLOOKUP(J7,D2:D21,E2:E21)
10	9	Central	Jardine	Ballpoint	36	4.99	179.64
11	10	Central	Kivell	Officer Book	42	23.95	1,005.90
12	11	Central	Gill	Color Pencil	46	8.99	413.54
13	12	Central	Kivell	Stapler	50	19.99	999.50
14	13	Central	Jardine	Pencil Set	50	4.99	249.50
15	14	Central	Gill	File Cover	53	1.29	68.37
16	15	Central	Morgan	File Box	55	12.49	686.95
17	16	Central	Andrews	Staff Book	66	1.99	131.34
18	17	Central	Smith	Pen Set	67	1.29	86.43
19	18	Central	Andrews	Notice Board	75	1.99	149.25
20	19	Central	Gill	Printer	80	8.99	719.20
21	20	Central	Smith	Printer Cartrige	87	15.00	1,305.00
22
23
24
25										for example we have sales data as shown below.
26										we want to calculate the units sold for the item "Desk". Using Xlookup function type =xlookup(J7,D2:D21,E2:E21) in any empty cell. In our case that cell is J8. here J7 is the lookup item i.e. "Desl", D2:D21 is the lookup array where excel will look for item "Desk". E2:E21 is the array where the units sold will be retrived that are "2".
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100