If not found-D3.xlsx

	A	B	C	D	E	F	G	I	J
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
8	7	Central	Morgan	Sticky Notes	28	$8.99	$251.72
9	8	Central	Andrews	Glue	28	$4.99	$139.72	Lookup Value	Units Sold
10	9	Central	Jardine	Ballpoint	36	$4.99	$179.64	Lead Pencil	Sorry Requested Item is not found
11	10	Central	Kivell	Officer Book	42	$23.95	$1,005.90		XLOOKUP(I10,D2:D21,E2:E21,"Sorry Requested Item is not found")
12	11	Central	Gill	Color Pencil	46	$8.99	$413.54	Syntax:
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
26
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