Hello,
I have one worksheet Definition where I have cca 200 countries and each country is assigned specific region code.
WORKSHEET Definition - Example:
Column CTR_CODE | Column Biz_reg
AM EU
AD EU
BH ME
etc.
In the same workbook I have worksheet Modified with again CTR_CODE, and here comes the task: I need to assign Biz_reg to all cells according to CTR_CODE/Biz_reg in worksheet Definition
WORKSHEET Modified - Before
Column CTR_CODE | Column Biz_reg
AM
AD
BH
WORKSHEET Modified - Expected Result:
Column CTR_CODE | Column Biz_reg
DE US
AD EU
BH ME
AM EU
Please, could someone help?
Jana
Bookmarks