Do you mean you need to pick up adjacent data from these names in your column? What is the structure of your data/report? Will these names change? How about some sample data?
One way that I am thinking of is having numerous IF statements for each country. But that would be too many IF formulas in one cell. I am sure there is an easier and cleaner way. I just have tofigure that out.
What do you mean by "it didn't work"? Did it return an error value or did it return an incorrect result? Did you set up a source table? Which cells contain the country code, and which cells contain the corresponding country name? Also, can you post the exact formula you tried?
Like I mentioned before the country code is given to us in one column (say D1:D10000). We do not have a list for the Country Names we want in the given data. (Should we create one?)
The formula we set up should return the country name of that country code. For instance, the formula should say, if country code is FR then country name is France, if not then if country code is GB then country name is UK and if it is none of the 17 countries we are interested in then blank for all the 10000 country codes. (Note: there can be multiple data points for the same country code, that's ok.)
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.