+ Reply to Thread
Results 1 to 2 of 2

Values are already exists in other worksheets

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    667

    Values are already exists in other worksheets

    Hi Experts,

    Please find here attached workbook, I am looking for your precious help and expertise to provide a formula so i can find the values from worksheet "Food_USA" in first two worksheet to find the the companies names which are already exists in CRM Accounts Contact worksheet or CRM Leads Food and i would like to also to give us worksheet name in which the same company name exists. The companies names are not exactly identical in the first two worksheets. So would like to request to you kindly do help me please.

    Regards,


    Neilesh
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,829

    Re: Values are already exists in other worksheets

    When you try comparing two fields that may not be the same it becomes very difficult, Im sure theres algorythms out there that will predict the likelihood of a match but they themselves would have to be fairly complex.

    For instance, a great one to use as an example is that Great British tradition the BBC

    In numerous places you will find this referred to as:
    BBC, B.B.C, British Broadcasting, British Broadcasting Corp, British Broadcasting Corp. ,British Broadcasting Corporation, The Beeb, The BBC etc etc

    You could do things such as removing punctuation which would resolve the 1st 2 or doing a Replace to change "Corporation to Corp", "Limited to Ltd", Removing "The" etc but comparing BBC in one sheet to "British Broadcasting Corporation" in another is never going to match up.
    If someone has helped you then please add to their Reputation

+ 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. [SOLVED] Check if cell is not empty and checks if worksheets already exists
    By rskay14 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-20-2014, 02:40 AM
  2. [SOLVED] Rename Excel Worksheets, Add Variable if worksheet name already exists
    By jessello in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-22-2013, 05:38 PM
  3. Replies: 1
    Last Post: 08-11-2013, 11:00 PM
  4. Replies: 2
    Last Post: 01-21-2013, 12:07 AM
  5. [SOLVED] check if worksheet already exists when auto creating worksheets form a list
    By y0rk1e72 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-06-2012, 04:53 PM
  6. Deleting cell data in worksheet A if it exists in worksheets B, how?
    By Bern78 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-08-2011, 06:22 AM
  7. [SOLVED] Worksheets Exists Code...
    By KimberlyC in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2005, 05:05 PM
  8. [SOLVED] Worksheet Exists? Invisible Worksheets?
    By Ken Loomis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2005, 09:05 PM

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