Find same value and show data

Question

How can I assign values from the Germany tab and column B to the World tab. If, of course, the value in cell A matches the cell A in the germany tab. (I already see the match in red. I still need the numbers to transfer.)

Example here: https://docs.google.com/spreadsheets/d/1pJZqpsWxy5CPvVmNHRZ29ZSTbUhfUiXvtABf1cwkmdY/edit?usp=sharing

Thanks.

Example here: https://docs.google.com/spreadsheets/d/1pJZqpsWxy5CPvVmNHRZ29ZSTbUhfUiXvtABf1cwkmdY/edit?usp=sharing

Thanks.

user_15627590 · Answer

=IFERROR(VLOOKUP(A1;Germany!A1:B;2;FALSE);0)

If you paste this formula along every cell in B in World, you will get your result. If it doesn't find the value in Germany it will return 0.

user_5632629 · Answer

use:

=INDEX(IFNA(VLOOKUP(A1:A; Germany!A:B; 2; 0)))

Find same value and show data

2 Answers