i have a data base of phone numbers
981002345
98239765
98106763
98105533
etc... actully i have 70K of them
i want vlookup this table to give me the circle it belongs to...
my table that i am trying to reffer it to looks like...
9810 delhi
9890 Mumbai
9823 chennai
is there a way i can do a partial lookup of the numbers and return the circle data? the 4 numbers are the first 4 of the phone numbers....
any suggestions?????
ranjan
Bookmarks