Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? : ) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? : ) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? : ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|