How to integrate these two sheets?

  • Thread starter Thread starter Burger
  • Start date Start date
B

Burger

I have two Excel sheets. The first sheet contains a list of countries in the
first column. The second sheet also consists of a list of countries in the
first column but with fewer countries, i.e., not all countries from the
first sheet are in the second sheet. The second column of the second sheet
contains data on a specific characteristic of the country on that row.

Now I would like to integrate the data from the second sheet into the first
sheet. In other words, I would like the data from the second column of the
second sheet, to be placed in one of the columns of the first sheet and the
data should be placed on the appropriate row (i.e., on the row with the
country that the data belongs to). The problem is that the second sheet does
not have all the countries from the first sheet but only a selection of them
(so the rows do not correspond). Otherwise, I could just copy-paste. Does
anyone know how to do this?

Thanks in advance!
 
Back
Top