+ Reply to Thread
Results 1 to 2 of 2

Macro/VBA - Partial Text Matching

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Office 365

    Macro/VBA - Partial Text Matching

    Hi guys,

    Within a workbook I've got a tab(Tab_A) with a list of "Book Tittles" sent it by an external source (20K rows approx). In another tab(Tab_B) I've got my reference list also with "Book Tittles" which I do own.

    In theory a relevant % of tittles included in the list provided by the external source should match with the ones I keep in my own list.

    The issue here is that not all the tittles are wrote in the same way. Depending of the data quality provided by the external source, the tittle could exclude or include articles, additional words etc...so is not that easy as to run a simple vlookup or index_match function. I need some kind of macro/formula that look into the first list and returns next to my list in tab_B, the potential match. Could be a model that returns the tittle from the source list when a few words in common are identified...or something similar.

    At the moment I'm using the following formula:

    =IFERROR(INDEX('Tab_A'!$A$2:$A$20000,MATCH('Tab_B'!$A2&"*",'Tab_A'!$A$2:$A$20000,0),1),"No Match found")

    Is there any VBA alternative that could potentially give me a better/more accurate result? (I'm new to VBA/programming)

    Many thanks,

  2. #2
    Forum Contributor
    Join Date
    Houston, TX
    MS-Off Ver
    Microsoft Office Professional Plus 2016

    Re: Macro/VBA - Partial Text Matching

    In this case, providing the data and some solid examples of how the titles differ could be of great use in recommending a better solution. As it is right now, I'm not sure what the best approach would be, because I don't have the data to guide me. Please post the data and we will try to help you.

+ 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. Conditional Formatting: Matching Partial Text
    By Alan_Bernardo in forum Excel General
    Replies: 1
    Last Post: 01-07-2017, 02:23 PM
  2. Matching partial text to partial text - is this possible?
    By ssergeant in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-02-2015, 12:17 PM
  3. Partial Matching of a text string
    By RapidoDave in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2013, 12:20 PM
  4. [SOLVED] VBA / Macro help needed for matching partial text string
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2013, 09:41 PM
  5. [SOLVED] Matching with partial text
    By grkchakri in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2012, 03:33 PM
  6. Partial Text matching
    By Periya in forum Excel General
    Replies: 0
    Last Post: 08-18-2011, 06:36 AM
  7. matching partial text within one cell to partial text within another
    By Solstice in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-03-2010, 09:13 PM

Tags for this Thread


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