Compaire two sheets and update prices based on Item code

[simonmiller]

Guys and Girls

Im going to try and explain this as best as I possibly can, but it is driving me crazy.

I have a price list from my supplier with the new prices.

I then have my Accounting software where I need to update the cost and retail prices. The problem I have is the Accounting software has allocated it`s own Unique ID for each item. So in order for me to bulk import this I need to keep this unique ID with the Actual Product ID together otherwise it will duplicate the product.

Here is a example


Sheet to be updated (Cost and Retail only) from PRICE LIST SHEET

Uneque ID	SKU	Product	Cost	Retail
as123dsa-123	040-5001	Fitting 1	5.00	10.00
2weer432-4523	040-5001	Fitting 2	6.00	10.00

<tbody>
</tbody>

PRICE LIST SHEET New Price list to copy from

SKU	Product	Cost	Retail
040-5000	Fitting 1	7.00	15.00
040-5001	Fitting 2	9.00	20.00

<tbody>
</tbody>

Please let me know if this is not clear.

Thank you very much

 

[MrKowz]

Try using the Index/Match function.

Assuming the Unique ID is in column A on "PRICE LIST SHEET" and SKU is in column A in "NEW PRICE"...

=INDEX('PRICE LIST SHEET'!A:A,MATCH(A2,'PRICE LIST SHEET'!B:B,0))