What formula?
 

I have a tab (Datalist) with a column that has a a list of countries in it.
I have another tab (Country List) that has 2 columns - Col A - a list of 50+
countries, Col B - the Geos that the countries belong to. I need is a
formula to say, look at cell C3 in the Datalist tab, and whatever country
that's listed, look on the Country List tab and place the correct Geo
associated with the country.

Can someone help me with this formula please? : )

What formula?
 

=IF(ISNA(VLOOKUP(C3,Datalist!$A$1:$B$50,2,0)),"Not
Found",VLOOKUP(C3,Datalist!$A$1:$B$50,2,0))

Replace the cell range with your actual range

--


Regards,


Peo Sjoblom


"KC" wrote in message
...
I have a tab (Datalist) with a column that has a a list of countries in it.
I have another tab (Country List) that has 2 columns - Col A - a list of
50+
countries, Col B - the Geos that the countries belong to. I need is a
formula to say, look at cell C3 in the Datalist tab, and whatever country
that's listed, look on the Country List tab and place the correct Geo
associated with the country.

Can someone help me with this formula please? : )

What formula?
 

Try this:

=VLOOKUP(C3,'Country List'!A:B,2,0)

If there is a chance that the country in your Datalist sheet may not
be included in the Country List sheet, then you cna change it to this
to avoid getting the #N/A error:

=IF(ISNA(VLOOKUP(C3,'Country List'!A:B,2,0)),"not
present",VLOOKUP(C3,'Country List'!A:B,2,0))

or some other message.

Hope this helps.

Pete

On May 2, 5:13*pm, KC wrote:
I have a tab (Datalist) with a column that has a a list of countries in it.. *
I have another tab (Country List) that has 2 columns - Col A - a list of 50+
countries, Col B - the Geos that the countries belong to. *I need is a
formula to say, look at cell C3 in the Datalist tab, and whatever country
that's listed, look on the Country List tab and place the correct Geo
associated with the country.

Can someone help me with this formula please? : )