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

Attached Files

Test Sheet.xlsx (87.8 KB, 6 views)

Cross post without links http://www.excelguru.ca/forums/showt...ed=1#post19886

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post