Hi,
Pls help me on this.

I have 2 excel sheets format is below mention. In sheet one i have some number with ISD code and in secound sheet i have country name and Code. now i want to match Country name in sheet one but my porblem is that there are some code are in 1 degit and some code are in 2,3,4,5 degits. If you see in example 220 is belong to Gambia and 224 belong to Guinea so first i want to match all code who is having 1 degit code second who is having 2 degit than 3 degit, 4 degit respectively.

As per Ist number 54911678222709 Formula will check Ist degit 5 if it is Match than ok else chek 54 if it's match than ok else check 549.

Sheet One:-
Caller Number
54911678222709
5493426121222
971501364886
9715013648860
2207771650
22430919600
23190000368
23222273217

Sheet two:-
Country Code Name
54 Argentina
54 Argentina
971 Emiratos Árabes Unidos
971 Emiratos Árabes Unidos
220 Gambia
224 Guinea
231 Liberia
232 Sierra Leona


is it possiable with combination of some formula like Len, vlookup etc?