Formula To LookUp For Revised Phone Number Having Variable Length Starting Digits

[Excel Fox]

Use C2=INDEX(Sheet2!$B$1:$B$61,MIN(IF(LEFT(A2,LEN(Shee t2!$A$1:$A$61))=""&Sheet2!$A$1:$A$61,ROW(INDIRECT( "1:"&ROWS(Sheet2!$A$1:$A$61))),"")))&A2 as array formula with the following sheets layout

So create a list like this in a sheet, say Sheet2

60	6
61	6
62	6
63	6
64	6
65	6
66	6
67	6
68	6
69	6
77	6
70	6
50	6
51	6
59	6
58	6
554	6
555	6
556	6
558	6
559	6
550	6
90	9
91	9
92	9
93	9
94	9
95	9
96	9
97	9
98	9
99	9
71	9
72	9
73	9
74	9
75	9
76	9
78	9
79	9
44	9
24	2
25	2
26	2
29	2
36	2
37	2
38	2
39	2
43	2
45	2
46	2
47	2
48	2
49	2
52	2
53	2
54	2
55	2
56	2
57	2

and in Sheet1 you have your list of phone numbers like this

Mobile	Name
6051504	Peter
7162761	Chan
9633574	Andrew
2483957	Li

Attached example for reference