+ Reply to Thread
Results 1 to 3 of 3

Partial Match not working against a complex string

  1. #1
    Registered User
    Join Date
    06-26-2009
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    2

    Partial Match not working against a complex string

    Hi,

    Ive got an issue matching against a complex string:

    String is in Column A
    Keword to Match is in Column B
    Equation to determine whether or not Keyword is in Column B is "=IF(ISNUMBER(MATCH("*"&B2&"*",A:A,0)),"Found","Not Found")"

    Column A String is: ahttp://m1.2mdn.net/931669/wine_728x90.swf?clickTag=http%3A//ad.ca.doubleclick.net/click%253Bh%3Dv8/3857/3/0/%252a/b%253B215842300%253B0-0%253B0%253B31234012%253B1-468/60%253B31943273/31961149/1%253B%253B%257Eaopt%253D2/2/4488/1%253B%257Esscs%253D%253fhttp%3A//www.montrealgazette.com/life/food-wine/wine-guide.html


    Column B Keyword is "wine"

    Column C still indicates "Not Found"

    Can anyone help on this issue?

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Partial Match not working against a complex string

    The string is too long for MATCH to work correctly (317 chars) perhaps then:

    =IF(COUNTIF(A:A,"*"&B2&"*"),"Found","Not Found")

  3. #3
    Registered User
    Join Date
    06-26-2009
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Partial Match not working against a complex string

    Thanks!!! It works now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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