POPULATE EXCEL SHEET

Job ID: 33183386

Budget: $10 – $30 AUD

Hi

refer sku.zip
I am updating my sku to my new stores.
4 shopee and 2 lazada store

I have an original sku in excel (original store-best.xlsx)

I would need assistance to populate the sku by picking up the sku from (original store-best.xlsx)
column K.

Condition of populating -if column D is matched and few words in column B is matched populate column K SKU.

You will need to assist me in populating all the 6 excels SKU .
Lazada sku - column S
Shopee SKU- Column K

Also provide the excel formula you used so I can use in future