I'm trying to replace a column of data (
Prodct SKU) on one sheet (a) with the corresponding value taken from 2 columns on sheet (b) (
Product SKU & Product ID).
I've attached the spreadsheet to help illustrate:
e.g. on column A Sheet A (
Product Sku) search for the corresponding
Product ID (column B sheet B) and enter the corresponding
Product ID value on Sheet A column B (
Current formula :
We'll have hundreds of products codes which will be added to frequently.
I've tried reading various online answers but I'm very confused