Results 1 to 3 of 3

Thread: VLOOKUP With Lookups that Don't Match

  1. #1

    VLOOKUP With Lookups that Don't Match



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I apologize if my title is misleading, I was trying to be as clear and as succinct as possible. I have a list of hotels and corresponding hotel IDs. I would like to be able to use VLOOKUPS to pull the hotel IDs based on hotel names that clients provide us. However, the hotels names that the clients use are not always exactly the same as the names on our list. Here is what I have done so far:

    1. Pull out the keywords in the hotel name and replace the spaces with wildcards, and then use the Find function (this works about 98% of the time, but is really slow and cannot be replicated to my knowledge):
    Hilton Phuket Arcadia Resort and Spa --> *Hilton*phuket*arcadia*

    2. I have tried pulling out the first 40 characters, replacing the spaces with wildcards and then using VLookUp, but that does not appear to work. I also tried replacing the spaces with &"*"&, so that the vlookup would be looking for:
    "*"&Hilton&"*"&phuket&"*"&arcadia&"*"

    3. I tried pulling each of the words out and putting them into their own cells:
    a3=Hilton
    c3=phuket
    d3=arcadia
    and then i used the cell reference as opposed to the actual word in the formula:
    "*"a3&"*"&c3&"*"&d3"*"

    None of these appeared to work. I would like to be able to paste the names of the hotels from the client into a column, and then have the formula return the hotel id that corresponds. It does not need to work for every single item as sometimes the client name is vastly different than the name we have on our list. Any help that you can provide would be great!

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    675
    Articles
    0
    Excel Version
    Excel 2010 64bit
    Google "FuzzyFind Function", there is a UDF (User Defined Function) out there somewhere that I've seen referenced in similar forum questions that could be of interest.

  3. #3
    You have your sample workbook? try to upload at the forum..

    Thanks

Posting Permissions

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