Populate column with values from another sheet based on common values

[TaxStudent]

I have one sheet (A) that looks like this:

Country      Year        Income

Argentina    2023      100

Argentina    2024      200

Argentina    2025      300

Australia     2023      100

Australia     2024      200

Australia     2025      300

Belgium      2023      100

Belgium      2024      200

Belgium      2025      300

Etc.

And another sheet (B) that looks like this (in its entirety):

Year         Rate

2023        50%

2024        50%

2025        37.5%

I'm trying to get a result (C) that looks like this:

Country       Year        Income     Rate

Argentina     2023       100           50%

Argentina     2024       200           50%

Argentina     2025       300           37.5%

Australia      2023       100           50%

Australia      2024       200           50%

Australia      2025       300           37.5%

Belgium       2023       100           50%

Belgium       2024       200           50%

Belgium       2025       300           37.5%

Etc.

I can see that what I want to do is get the rates from sheet B to append to the end of sheet A based on the relationship between the years in sheet B and sheet A. But, I cannot think of a tool or combination of tools that can achieve this result.

Do you have any ideas?

[Qiu · Accepted solution]

@TaxStudent 

We can use the Find and Replace or Join tool for this case.

[saveeshkumar]

Hi @TaxStudent ,

Hope this will help you

Thanks

[TaxStudent]

Thank you (谢谢!) both for the responses! I went with Qiu's suggestion using Find and Replace. It took me a few minutes to realize it would only work after I converted the years from doubles to v_strings. Works like a charm, now!