Update Pricing

[MrCOSTCO]

Hello, I am new to excel formulas. I need to replace old pricing with new pricing, however, I only have the manufacturer's product numbers as a "link" between pricing. This is a sample from my sheet.

Manufact. SKU	Old Price		Manufact. SKU	New Price
	$6.95		00.0000.200.041	$ 20.00
00.6415.045.000	$35.95		00.0000.200.289	$ 35.00
	$199.95		00.0000.200.290	$ 35.00
00.6415.041.010	$209.95		00.0000.200.292	$ 35.00
00.6415.045.020	$199.95		00.0000.200.293	$ 17.00
00.6415.041.000	$64.00		00.0000.200.330	$ 26.00
00.6415.033.000	$41.00		00.0000.200.367	$ 34.00
	$335.95		00.0000.200.393	$ 44.00
	$154.95		00.0000.200.394	$ 44.00
	$61.95		00.0000.200.395	$ 26.00
00.5115.048.020	$72.00		00.0000.200.396	$ 26.00
00.5115.048.030	$72.00		72.2742.200.750	$ 17.00
	$99.95		72.2740.200.751	$ 17.00
00.5115.056.000	$75.95		86.2706.114.105	$ 17.00
00.6415.035.000	$41.95		87.2745.114.105	$ 22.00
	$29.95		00.1918.336.002	$ 0.00
00.6415.035.010	$219.95		00.1918.336.003	$ 0.00
	$74.95		00.1918.336.001	$ 0.00
00.7915.017.130	$33.00		11.4307.250.000	$ 15.00
	$42.95		11.4308.848.000	$ 53.00
00.5215.012.010	$69.95		11.4308.849.000	$ 80.00
00.7915.042.000	$22.00		11.4309.207.000	$ 53.00
	$9.95		00.6415.001.000	$ 39.00
	$33.00		00.7900.001.000	$ 35.00
00.5018.100.001	$132.95		85.2737.270.074	$ 17.00
	$9.95		11.5115.000.000	$ 18.00
200-750	$4.50		00.2415.009.000	$ 35.00
200-751	$15.95		48.2723.114.005	$ 18.00

[#2]

@MrCOSTCO The attached workbook contains a working example based on the data you provided, assuming you can use XLOOKUP (see column C. Alternatively, use VLOOKUP (see column D).

I changed a few codes so that there would in fact be matching SKU's. 

[#3]

@Riny_van_Eekelen 

Could you give this a look? I tried but not everything populated.

[#4]

@MrCOSTCO Ooops! I forgot to add some $ signs in my file when I entered the VLOOKUP formula. See attached.

[#5]

@MrCOSTCO 

As a variant see File