What formula?

[KC]

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? : )

 

[Peo Sjoblom]

=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

 

[Pete_UK]

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