Splitting International Dialing codes into country and area code.

S

stefansfs

New member
Joined
Aug 17, 2015
Messages
2
Reaction score
0
Points
0
Good day,

I have the following columns :

A
Dailing Codes
1 93
2 937
3 355
4 35538
5 35566
6 213
7 2135
8 2136
9 1684
.
.
.
.
.
.
------

B
Country Codes
1 93
2 355
3 213
4 376
5 244
6 1
7 44
.
.
.
.
.


---------

Please assist with the following :

Match the Dialing codes against the country codes from Left to right. if match is found return the country code in column C and the area code in column C. E.G. Dialing code 93(A1) is matched against Array (B1:B210) Country Codes. As 93 is found in the Country Codes array , 93 will be returned as Country Code. Next row : Dialing code 937(A2) is matched against Array (B1:B210) Country Codes. As 93 is found in the Country Codes array , 93 will be returned as Country Code and 7 will be returned as area code. Please refer to attached sample File for sample data.

Kind regards

Stefan
 

Attachments

  • Test Sheet.xlsx
    87.8 KB · Views: 9
Hi,
plz find attachment.
 

Attachments

  • Test.xlsx
    309.4 KB · Views: 11
Hi,

Thanks a million. Somehow, if a dialing code starts with 1 e.g 1684 (A26) , the vlookup in the helper column does not find the 1 in the E Column (Country codes). any idea why ?

br

Stefan
 
You must log in or register to reply here.
Back
Top