+ Reply to Thread
Results 1 to 2 of 2

Vlookup fuzzy search

  1. #1
    Registered User
    Join Date
    12-22-2013
    Location
    united states
    MS-Off Ver
    Excel 2013
    Posts
    64

    Vlookup fuzzy search

    Hi there,

    I am hoping someone can help me out with the following:

    I would like to do a vlookup for a value but have it do a "fuzzy" or approximate search in the array as opposed to an exact value. I have attached my workbook for reference.

    For eample I have this in column A 118 Doreen St but this in column E 118 Doreen St, New Bedford, MA, 02744


    I would like the Formula to start in C1 and pull the dates from column f.

    Thanks in advance !

    Book2.xlsx

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Vlookup fuzzy search

    Try this formula
    in C2 and copy it down

    =VLOOKUP(B1&"*",$E$1:$F$3,2,0)
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. fuzzy search
    By tixbeast in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2013, 02:03 PM
  2. Using VBA to search for a string (fuzzy logic)
    By masond3 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-30-2013, 09:26 AM
  3. Fuzzy Lookup Search for 2 or 3 columns
    By kashifahmed in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-04-2013, 02:55 PM
  4. Fuzzy Logic - search for similar values
    By mojo249 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2012, 02:11 PM
  5. Cell search fuzzy word match lookup
    By datacruncher in forum Excel General
    Replies: 1
    Last Post: 12-03-2009, 07:05 AM

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