Need to show particular country name in attached sheet as per ID

**abhiindia123** · 06-30-2013, 10:16 AM

Hi,

In the attached sheet, column A contains the organization ID of various organizations as SL001004 or IN0001982. I need to write a function which will show the country name as "SRI LANKA" for a ID starting as SL or "INDIA" for a ID starting as IN in the column E.
I tried working it out with the IF function.
Needless to say, did not work.

Please help.

Best,

Abhinav

**Spencer101** · 06-30-2013, 10:26 AM

This is one of several ways of accomplishing this (see attached).

**AZ-XL** · 06-30-2013, 10:55 AM

There are two different way of doing it in attached file.
One if IF formula solution.
E1 cell =IF(LEFT(A2,2)="SL","Sri Lanka", IF(LEFT(A2,2)="IN","India","Different Country"))

Another way is creating table for Country ID-s. Its more efficient if there are many countries.

See the attached file.