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 ,

I don't know if this would help you. If not let me know what changes could be applied.

Regards

[DaRo]

Hi @afv2688, 

Thank you! Is it possible to change the flow and obtain the following output? 

On the right I have a bunch of other variables related to that year, office/system 

Year	Office/System	Office	System	Region	Variable X	Variable Y
2020	1	1	A	Europe
2020	2	2	B	Asia
2020	A		A	Europe
2019	B		B	Asia
2019	1	1	B	Asia
2018	A		A	Europe

Regards

[afv2688 · Accepted solution]

Hello @DaRo ,

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

Regards