Help with Advanced Bulk Matching

[BigMike23]

Hello,

I am wanting to create a function that goes as follows: If the number in column E matches one of the cells in column A, then post the UPC number in the same row as the matched number in column A in column F.

So for example if E2 matched with A13, then the UPC in C13 would be posted in F2.

(picture 2) The only issue is that there are only 212 numbers in Column E while there are 293 numbers in column A. I'm wanting the UPC for every number in column E then somehow have a way to mark or highlight the UPC's already used so I can extract the ones that weren't used.

 

[kevin9999]

I think a simple Vlookup would probably give you what you want. Nobody's going to type in all your data from an image, in future please look at using the XL2BB add in to provide a sample of your data. In the meantime, see if the demo below satisfies your needs:

green.xlsm
	A	B	C	D	E	F
1	Part number	Name	UPC	UPC
2	123	x	494115	455867	125	468243
3	124	x	425813	413117	151
4	125	x	468243	450166	129	421016
5	126	x	433866	411818	131	414263
6	127	x	419826	442687	132	497257
7	128	x	461836	419859	133	424823
8	129	x	421016	461837	124	425813
9	130	x	444327	472727
10	131	x	414263	403418
11	132	x	497257	448829
12	133	x	424823	483915
13	134	x	474441	466271
14	135	x	462070	443367
15	136	x	450722	492317
16	137	x	412681	493971
17	138	x	497697	493151
18	139	x	478048	439849
19	140	x	484223	492316
20	141	x	460918	497649
21	142	x	405279	448660
Sheet4

Cell Formulas
Range	Formula
F2:F21	F2	=IFERROR(VLOOKUP(E2,$A$2:$C$21,3,FALSE),"")