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

[mahmoud-lee]

These telephone numbers have changed so I want to add new numbers to the numbers in column with red color

[patel]

I'm sorry, but I did understand nothing

[mahmoud-lee]

Simply
I want these numbers like this

[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

[mahmoud-lee]

Wonderful
Very Good solution
thank you