Need formula that joins field in one table to field in another table

[tblackwell]

Windows 10 Pro, Office 365
My question: I have a field in table A that I want to join to table B and place in a new table C. I cannot figure out the formula to do this.
Table A contains two fields: Store_Number and Group_Name.
Table B contains four fields: Group_Name, Item_Number, Item Description, and Price
Table C is the desired outcome: Store_Number, Item_Number, and Price
I cannot figure out how to build table C with a formula if Store_Number is the starting field.
Any suggestions?

item_description_group_twb2.xlsx
	A	B
1	Store_Number	Group_Name
2	6001	KC
3	6002	KC
4	6003	KC
5	6004	KC
6	6005	KC
7	6006	KC
8	6007	KC
9	6008	KC
10	6009	KC
11	6010	KC
12	6011	KC
13	6012	KC
14	6013	KC
15	6014	KC
16	6015	KC
17	6017	KC
18	6018	KC
19	6019	KC
20	6021	KC
21	6022	KC
22	6023	KC
23	6024	KC
24	6025	KC
25	6026	KC
26	6027	KC
27	6028	KC
28	6029	KC
29	6031	KC
30	6032	KC
31	6033	KC
32	6034	KC
33	6035	KC
34	6036	KC
35	6037	KC
36	6038	KC
37	6041	KC
38	6050	SLC Core
39	6051	SLC Core
40	6052	SLC Core
41	6053	SLC Core
42	6054	SLC Core
43	6055	SLC Core
44	6057	SLC Core
45	6058	SLC Core
46	6059	SLC Core
47	6060	SLC Core
48	6061	SLC Core
49	6062	SLC Core
50	6063	SLC Core
51	6064	SLC Core
52	6065	SLC Core
53	6066	SLC Core
54	6067	SLC Core
55	6068	SLC Core
56	6069	SLC Core
57	6071	SLC Core
58	6072	SLC Core
59	6073	SLC Core
60	6074	SLC Core
61	6075	SLC Prem
62	6076	SLC Core
63	6077	SLC Core
64	6078	SLC Core
65	6079	SLC Core
66	6081	SLC Core
67	6082	SLC Core
68	6083	SLC Core
69	6084	SLC Core
70	6086	SLC Core
71	6087	SLC Core
72	6088	SLC Core
73	6089	SLC Core
74	6090	SLC Core
75	6091	SLC Core
76	6092	SLC Prem
77	6093	SLC Core
78	6094	SLC Core
79	6095	SLC Core
80	6096	SLC Core
81	6097	SLC Core
82	6098	SLC Core
83	6099	SLC Core
84	6100	SLC Core
85	6101	SLC Core
86	6103	SLC Core
87	6104	SLC Core
88	6105	SLC Core
89	6106	SLC Core
90	6200	NC Core
91	6201	NC Core
92	6202	NC Core
93	6203	NC Core
94	6204	NC Core
95	6205	NC Core
96	6206	NC Core
97	6207	NC Core
98	6209	NC Core
99	6210	NC Core
100	6211	NC Core
101	6212	NC Core
102	6213	NC Core
103	6214	NC Core
104	6215	NC Core
105	6216	NC Core
106	6217	NC Core
107	6218	NC Core
108	6219	NC Core
109	6220	NC Core
110	6221	NC Core
111	6222	NC Core
112	6223	NC Core
113	6224	NC Core
114	6225	NC Core
115	6226	NC Core
116	6227	NC Core
117	6228	NC Core
118	6229	NC Core
119	6231	NC Core
120	6232	NC Core
121	6233	NC Core
122	6234	NC Core
123	6235	NC Core
124	6236	NC Core
125	6237	NC Core
126	6238	NC Core
127	6239	NC Core
128	6240	NC Core
129	6241	NC Core
130	6242	NC Core
131	6243	NC Core
132	6244	NC Core
133	6245	NC Core
134	6246	NC Core
135	6247	NC Core
136	6248	NC Core
137	6249	NC Core
138	6250	NC Core
139	6251	NC Core
140	6252	NC Core
141	6255	NC Core
142	6256	NC Core
143	6257	NC Core
144	6258	NC Core
145	6260	NC Core
146	6261	NC Core
147	6262	NC Core
148	6300	Raleigh Value
149	6301	Raleigh Value
150	6302	Raleigh Value
151	6303	Raleigh Value
152	6304	Raleigh Value
153	6305	Raleigh Value
154	6306	Raleigh Value
155	6308	Raleigh Value
156	6309	Raleigh Value
157	6310	Raleigh Value
158	6311	Raleigh Value
159	6312	Raleigh Value
160	6313	Raleigh Value
161	6314	Raleigh Zone 3
162	6315	Raleigh Zone 3
163	6316	Raleigh Value
164	6317	Raleigh Value
165	6318	Raleigh Value
166	6319	Raleigh Value
167	6320	Raleigh Value
168	6321	Raleigh Value
169	6322	Raleigh Zone 3
170	6323	Raleigh Zone 3
171	6324	Raleigh Zone 3
172	6325	Raleigh Value
173	6326	Raleigh Value
174	6327	Raleigh Value
175	6328	Raleigh Value
176	6329	Raleigh Value
177	6330	Raleigh Value
178	6332	Raleigh Value
179	6333	Raleigh Zone 3
180	6334	Raleigh Zone 3
181	6335	Raleigh Value
182	6336	Raleigh Value
183	6337	Raleigh Value
184	6338	Raleigh Value
185	6339	NC Core
186	6341	NC Walker
187	6342	NC Walker
188	6343	NC Walker
189	6344	NC Walker
190	6345	NC Walker
191	6346	NC Walker
192	6347	NC Walker
193	6348	NC Walker
194	6349	NC Walker
195	6350	NC Walker
196	6400	PA
197	6401	PA
198	6402	PA
199	6403	PA
200	6404	PA
201	6405	PA
202	6406	PA
203	6407	PA
204	6408	PA
205	6409	PA
206	6410	PA
207	6411	PA
208	6412	PA
209	6413	PA
210	6414	PA
211	6415	PA
212	6416	PA
213	6417	PA
214	6418	PA
215	6420	PA
216	6421	PA
217	6422	PA
218	6423	PA
219	6424	PA
220	6425	PA
221	6426	PA
222	6427	PA
223	6428	PA
224	6429	PA
225	6430	PA
226	6431	PA
227	6432	PA
228	6433	PA
229	6434	PA
230	6435	PA
231	6436	PA
232	6437	PA
233	6438	PA
234	6439	PA
235	6440	PA
236	6441	PA
237	6442	PA
238	6443	PA
239	6444	PA
240	6445	PA
241	6446	PA
242	6447	PA
243	6448	PA
244	6449	PA
245	6450	PA
246	6451	PA
247	6452	PA
248	6453	PA
249	6454	PA
250	6455	PA
251	6456	PA
252	6457	PA
253	6458	PA
254	6459	PA
255	6460	PA
256	6461	PA
257	6462	PA
258	6501	DMV Zone 1
259	6502	DMV Zone 2
260	6503	DMV Zone 1
261	6504	DMV Zone 2
262	6505	DMV Zone 2
263	6506	DMV Zone 1
264	6507	DMV Zone 2
265	6508	DMV Zone 1
266	6509	DMV Zone 3
267	6510	DMV Zone 1
268	6511	DMV Zone 1
269	6513	DMV Zone 2
270	6514	DMV Zone 1
271	6515	DMV Zone 1
272	6516	DMV Zone 2
273	6517	DMV Zone 1
274	6518	DMV Zone 1
275	6519	DMV Zone 1
276	6520	DMV Zone 1
277	6521	DMV Zone 2
278	6522	DMV Zone 3
279	6523	DMV Zone 1
280	6524	DMV Zone 1
281	6525	DMV Zone 2
282	6526	DMV Zone 1
283	6527	DMV Zone 3
284	6528	DMV Zone 1
285	6529	DMV Zone 1
286	6530	DMV Zone 1
287	6531	DMV Zone 1
288	6532	DMV Zone 1
289	6534	DMV Zone 1
290	6535	DMV Zone 3
291	6536	DMV Zone 1
292	6537	DMV Zone 1
293	6538	DMV Zone 2
294	6540	DMV Zone 1
295	6541	DMV Zone 1
296	6542	DMV Zone 1
297	6543	DMV Zone 2
298	6544	DMV Zone 1
299	6545	DMV Zone 1
300	6546	DMV Zone 2
301	6547	DMV Zone 1
302	6548	DMV Zone 2
303	6549	DMV Zone 2
304	6550	DMV Zone 2
305	6552	DMV Zone 1
306	6553	DMV Zone 1
307	6554	DMV Zone 1
308	6555	DMV Zone 2
309	6556	DMV Zone 2
310	6557	DMV Zone 2
311	6558	DMV Zone 1
312	6559	DMV Zone 1
313	6560	DMV Zone 1
314	6562	DMV Zone 2
315	6563	DMV Zone 1
316	6564	DMV Zone 1
317	6565	DMV Zone 2
318	6566	DMV Zone 2
319	6567	DMV Zone 1
320	6568	DMV Zone 1
321	6569	DMV Zone 2
322	6570	DMV Zone 1
323	6571	DMV Zone 1
324	6572	DMV Zone 1
325	6573	DMV Zone 1
326	6574	DMV Zone 1
327	6575	DMV Zone 1
328	6576	DMV Zone 2
329	6577	DMV Zone 1
330	6578	DMV Zone 1
331	6579	DMV Zone 1
332	6580	DMV Zone 1
333	6581	DMV Zone 2
334	6582	DMV Zone 1
335	6583	DMV Zone 1
336	6584	DMV Zone 1
337	6585	DMV Zone 2
338	6586	DMV Zone 1
339	6587	DMV Zone 1
340	6588	DMV Zone 1
341	6589	DMV Zone 1
342	6590	DMV Zone 1
343	6591	DMV Zone 1
344	6592	DMV Zone 2
345	6593	DMV Zone 1
346	6594	DMV Zone 3
347	6595	DMV Zone 2
348	6596	DMV Zone 1
349	6597	DMV Zone 1
350	6598	DMV Zone 1
351	6599	DMV Zone 1
352	6600	DMV Zone 1
353	6601	DMV Zone 2
354	6602	DMV Zone 1
355	6603	DMV Zone 1
356	6604	DMV Zone 1
357	6605	DMV Zone 1
358	6606	DMV Zone 2
359	6607	DMV Zone 1
360	6608	DMV Zone 1
361	6609	DMV Zone 2
362	6610	DMV Zone 1
363	6611	DMV Zone 1
364	6612	DMV Zone 1
365	6613	DMV Zone 1
366	6614	DMV Zone 1
367	6615	DMV Zone 1
368	6616	DMV Zone 1
369	6617	DMV Zone 1
370	6618	DMV Zone 3
371	6619	DMV Zone 1
372	6620	DMV Zone 1
373	6621	DMV Zone 1
374	6622	DMV Zone 1
375	6623	DMV Zone 1
376	6624	DMV Zone 1
377	6625	DMV Zone 1
378	6626	DMV Zone 2
379	6627	DMV Zone 1
380	6628	DMV Zone 1
381	6629	DMV Zone 1
382	6630	DMV Zone 1
383	6631	DMV Zone 1
384	6632	DMV Zone 1
385	6633	DMV Zone 2
386	6634	DMV Zone 1
387	6635	DMV Zone 1
388	6636	DMV Zone 3
389	6637	DMV Zone 2
390	6638	DMV Zone 1
391	6639	DMV Zone 1
392	6640	DMV Zone 1
393	6641	DMV Zone 1
394	6646	DMV Zone 1
Table A

item_description_group_twb2.xlsx
	A	B	C	D
1	Group_Name	Item_Number	Item Description	Price
2	KC	10200	CLASS SINGLE CH	4.29
3	KC	2074	SINGLE CHEESE COMBO	7.09
4	KC	10150	CLASS DOUBLE CH	5.29
5	KC	2067	CL DBL CH COMBO	8.09
6	KC	10250	CLASS TRIPLE CH	6.29
7	KC	2068	CL TRP CH COMBO	9.09
8	SLC Core	10200	CLASS SINGLE CH	4.29
9	SLC Core	2074	SINGLE CHEESE COMBO	7.09
10	SLC Core	10150	CLASS DOUBLE CH	5.29
11	SLC Core	2067	CL DBL CH COMBO	8.09
12	SLC Core	10250	CLASS TRIPLE CH	6.29
13	SLC Core	2068	CL TRP CH COMBO	9.09
14	NC Core	10200	CLASS SINGLE CH	4.09
15	NC Core	2074	SINGLE CHEESE COMBO	6.89
16	NC Core	10150	CLASS DOUBLE CH	5.09
17	NC Core	2067	CL DBL CH COMBO	7.89
18	NC Core	10250	CLASS TRIPLE CH	6.09
19	NC Core	2068	CL TRP CH COMBO	8.89
Table B

item_description_group_twb2.xlsx
	A	B	C
1	Store_Number	Item_Number	Price
2	6001	10200	4.29
3	6001	2074	7.09
4	6001	10150	5.29
5	6001	2067	8.09
6	6001	10250	6.29
7	6001	2068	9.09
8	6002	10200	4.29
9	6002	2074	7.09
10	6002	10150	5.29
11	6002	2067	8.09
12	6002	10250	6.29
13	6002	2068	9.09
14	6003	10200	4.29
15	6003	2074	7.09
16	6003	10150	5.29
17	6003	2067	8.09
18	6003	10250	6.29
19	6003	2068	9.09
20	6050	10200	4.29
21	6050	2074	7.09
22	6050	10150	5.29
23	6050	2067	8.09
24	6050	10250	6.29
25	6050	2068	9.09
26	6051	10200	4.29
27	6051	2074	7.09
28	6051	10150	5.29
29	6051	2067	8.09
30	6051	10250	6.29
31	6051	2068	9.09
32	6052	10200	4.29
33	6052	2074	7.09
34	6052	10150	5.29
35	6052	2067	8.09
36	6052	10250	6.29
37	6052	2068	9.09
38	6200	10200	4.29
39	6200	2074	7.09
40	6200	10150	5.29
41	6200	2067	8.09
42	6200	10250	6.29
43	6200	2068	9.09
44	6201	10200	4.29
45	6201	2074	7.09
46	6201	10150	5.29
47	6201	2067	8.09
48	6201	10250	6.29
49	6201	2068	9.09
50	6202	10200	4.29
51	6202	2074	7.09
52	6202	10150	5.29
53	6202	2067	8.09
54	6202	10250	6.29
55	6202	2068	9.09
Table C - Desired Outcome