I have 250 names of towns in work sheet " DU " starting at cell D26 down to
D250.
those names are like this : Dubbo (g7)
Darwin (a2)
Sydney (k5) and so on .
In work sheet " Towns " column " B " I have the same names without the last
4 caracters, (g7) , (a2) , (k5) like this Dubbo
Darwin
Sydney
In column " C " opposite the towns names I have a distance number 505

220

710
In column cell " A45 " I have the formula
=LEFT(DU!D26,LEN(DU!D26)-RIGHT(4))
which gives me the name of the town wihout the last 4 caracters Dubbo

Darwin

Sydney
In column ' L " I have a lookup function: =VLOOKUP(A45,B2:C250,2,FALSE)
which should give me :- 505 , but it returns #N/A

Can any one help me please

thank you for your time
regards B Gras