Join/Index Match HELP

DaRo

Hi all,

I have this two tables:

Year	Office	System	Region
2020	1	A	Europe
2020	2	B	Asia
2019	1	B	Asia
2019	2	B	Asia
2018	1	A	Europe

Year	Office/System
2020	1
2020	2
2020	A
2019	B
2019	1
2018	A

I need to map in the second table on the right both the related system and region (two more columns) by year.

I tried with find and replace but it only implies one key.

Can you please help?

Thank you

afv2688

Hello @DaRo ,

Changed the workflow, lets see if now it works fow you 🙂

Regards

office - system.yxmd