+ Reply to Thread
Results 1 to 2 of 2

how do i VLOOKUP for partial value?

  1. #1
    Registered User
    Join Date
    12-03-2006
    Posts
    3

    how do i VLOOKUP for partial value?

    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

  2. #2
    Forum Contributor
    Join Date
    03-15-2005
    Location
    North Carolina
    MS-Off Ver
    2003 & 2007
    Posts
    180
    This is close but i'm not completely satisfied with it yet.

    =VLOOKUP("9823",LEFT(A100:B100,4),2,FALSE)

    Its an array formula so enter it Ctrl-Shift-Enter

    I will play with this some more.
    jtp

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1