+ Reply to Thread
Results 1 to 2 of 2

Exclude From MATCH Search

  1. #1
    Registered User
    Join Date
    10-22-2010
    Location
    Oslo
    MS-Off Ver
    Excel 2007
    Posts
    2

    Exclude From MATCH Search

    I have just used MATCH and VLOOKUP to match cells from two lists that contain the same words.

    if I had the word "peter" in one list, I would match it with for example www.adfaf.com/peter

    But how do I omit a string like "http://", so that "http://" would not be registered by the match function.
    So that "http://www.abcdefg.com" would not be matched with for example "http://www.gfedcba.no"

    Should I insert anything into this formula?

    =MATCH("*"&LEFT(A1;4)&"*";Sheet2!B:B;0)

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Exclude From MATCH Search

    Perhaps you can use an IF like

    =IF(LEFT(A1;4)="http","Error",MATCH("*"&LEFT(A1;4)&"*";Sheet2!B:B;0))
    Audere est facere

+ 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