Update Pricing

New Contributor

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. SKUOld Price Manufact. SKUNew 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
4 Replies

@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. 

@Riny_van_Eekelen 

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

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

@MrCOSTCO 

As a variant see File

Yea_So_0-1632363241556.png