I have a set of data in sheet 1 column A like below
Germany
United Kingdom
Australia; Bulgaria; Czech Republic; Estonia; Germany; Hungary; India; Latvia; Lithuania; New Zealand; Romania; Singapore; Taiwan; Ukraine; United Kingdom; United States
Japan; Korea (South); Singapore; Taiwan
United Kingdom
Brazil; Canada; Colombia; India; Mexico; Netherlands; Philippines; Russia; South Africa; Spain; Ukraine; South Korea; USA
United Kingdom
United Kingdom
Mexico
United Kingdom
United Kingdom
United Kingdom
Argentina; Australia; Germany; Ireland; Poland; United States
United Kingdom
and in another sheet2 I have on cell with the below data of all african countries like below
ZIMBABWE,ZAMBIA,SOUTH AFRICA,UGANDA,TANZANIA, UNITED REPUBLIC OF,TOGO,CHAD,SWAZILAND,SOUTH SUDAN,SOMALIA,SIERRA LEONE,SENEGAL,SUDAN,RWANDA,NIGERIA,NIGER,NAMIBIA,MALAWI,MAURITIUS,MAURITANIA,MOZAMBIQUE,MALI,MADAGASCAR,LESOTHO,LIBERIA,KENYA,EQUATORIAL GUINEA,GUINEA-BISSAU,GAMBIA,GUINEA,GHANA,GABON,ETHIOPIA,WESTERN SAHARA,ERITREA,DJIBOUTI,CAPE VERDE,CONGO,CONGO, THE DEMOCRATIC REPUBLIC OF THE,CAMEROON,CÔTE D'IVOIRE,CENTRAL AFRICAN REPUBLIC,BOTSWANA,BURKINA FASO,BENIN,BURUNDI,ANGOLA,
I want to put a vlookup in sheet 1 column b with sheet 2 and find how many lines have the African countries listed in sheet 1 column b.
Please help with a procedure.
Germany
United Kingdom
Australia; Bulgaria; Czech Republic; Estonia; Germany; Hungary; India; Latvia; Lithuania; New Zealand; Romania; Singapore; Taiwan; Ukraine; United Kingdom; United States
Japan; Korea (South); Singapore; Taiwan
United Kingdom
Brazil; Canada; Colombia; India; Mexico; Netherlands; Philippines; Russia; South Africa; Spain; Ukraine; South Korea; USA
United Kingdom
United Kingdom
Mexico
United Kingdom
United Kingdom
United Kingdom
Argentina; Australia; Germany; Ireland; Poland; United States
United Kingdom
and in another sheet2 I have on cell with the below data of all african countries like below
ZIMBABWE,ZAMBIA,SOUTH AFRICA,UGANDA,TANZANIA, UNITED REPUBLIC OF,TOGO,CHAD,SWAZILAND,SOUTH SUDAN,SOMALIA,SIERRA LEONE,SENEGAL,SUDAN,RWANDA,NIGERIA,NIGER,NAMIBIA,MALAWI,MAURITIUS,MAURITANIA,MOZAMBIQUE,MALI,MADAGASCAR,LESOTHO,LIBERIA,KENYA,EQUATORIAL GUINEA,GUINEA-BISSAU,GAMBIA,GUINEA,GHANA,GABON,ETHIOPIA,WESTERN SAHARA,ERITREA,DJIBOUTI,CAPE VERDE,CONGO,CONGO, THE DEMOCRATIC REPUBLIC OF THE,CAMEROON,CÔTE D'IVOIRE,CENTRAL AFRICAN REPUBLIC,BOTSWANA,BURKINA FASO,BENIN,BURUNDI,ANGOLA,
I want to put a vlookup in sheet 1 column b with sheet 2 and find how many lines have the African countries listed in sheet 1 column b.
Please help with a procedure.