Copy of Index & Match Function

	A	B	C	D	E	F	G	J	K	L	M	N	O	P
1	ZONE	GROUP	EMP-ID	JAN	FEB	MAR	APR
2	NORTH	A	V10001	63	51	70	96
3	SOUTH	D	V10002	81	54	58	77	Index & Match
4	EAST	A	V10003	66	62	57	65	EMP-ID	ZONE	GROUP	JAN	FEB	MAR	APR
5	NORTH	D	V10004	94	59	87	88	V10008	WEST	A	87	76	99	93
6	EAST	B	V10005	84	76	99	88	V10009	WEST	D	68	86	64	69
7	NORTH	A	V10006	65	65	79	90	V100045	NORTH	B	55	59	90	62
8	WEST	C	V10007	79	87	98	52	V100046	SOUTH	A	80	100	70	70
9	WEST	A	V10008	87	76	99	93	V100047	WEST	D	66	76	63	95
10	WEST	D	V10009	68	86	64	69	V100048	EAST	B	71	81	61	51
11	NORTH	D	V100010	70	74	93	59
12	NORTH	A	V100011	62	55	75	83
13	WEST	C	V100012	79	87	95	76
14	WEST	B	V100013	93	88	75	73	Index & Match
15	NORTH	B	V100014	88	71	58	75	EMP-ID	ZONE	GROUP	JAN	FEB	MAR	APR
16	SOUTH	D	V100015	85	91	68	64	V10008
17	WEST	B	V100016	64	97	53	93	V10009
18	EAST	D	V100017	87	74	84	59	V100045
19	EAST	B	V100018	72	93	58	84	V100046
20	SOUTH	D	V100019	98	90	65	75	V100047
21	SOUTH	B	V100020	96	83	90	76	V100048
22	NORTH	A	V100021	60	84	76	87
23	SOUTH	A	V100022	76	95	68	81
24	NORTH	D	V100023	64	83	77	95
25	EAST	C	V100024	73	98	63	88
26	NORTH	C	V100025	79	55	96	74
27	SOUTH	B	V100026	82	88	53	97
28	SOUTH	A	V100027	59	93	91	90
29	NORTH	D	V100028	65	54	63	95
30	SOUTH	B	V100029	92	76	67	73
31	WEST	B	V100030	99	94	53	57
32	EAST	A	V100031	99	70	70	98
33	EAST	D	V100032	55	79	81	56
34	SOUTH	A	V100033	76	58	89	74
35	SOUTH	C	V100034	63	83	58	78
36	EAST	B	V100035	62	60	87	58
37	EAST	C	V100036	77	70	79	80
38	NORTH	B	V100037	85	98	98	85
39	SOUTH	C	V100038	50	83	98	52
40	NORTH	D	V100039	85	70	65	57
41	EAST	C	V100040	95	64	59	74
42	NORTH	C	V100041	97	52	99	66
43	EAST	A	V100042	95	99	77	94
44	NORTH	C	V100043	81	85	53	60
45	WEST	B	V100044	81	90	87	79
46	NORTH	B	V100045	55	59	90	62
47	SOUTH	A	V100046	80	100	70	70
48	WEST	D	V100047	66	76	63	95
49	EAST	B	V100048	71	81	61	51
50	EAST	A	V100049	79	55	69	84
51	NORTH	C	V100050	90	62	97	67
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