+ Reply to Thread
Results 1 to 6 of 6

Help finding text within a different cell

  1. #1
    Forum Contributor
    Join Date
    06-21-2014
    Location
    Brighton
    MS-Off Ver
    2011
    Posts
    115

    Help finding text within a different cell

    Hope some one can help me.

    I have a list of nearly 1million lines of text in two columns.

    Column A contains URLs
    Column B contains Keywords which wear searched in google to return the URL.

    I'm looking to search the text in column B and compare with the text in column A to try to find matching text.

    For example;
    Screen Shot 2014-06-21 at 10.49.58.png

    C1: TRUE as the word "footasylum" in cell B1 is also found in cell A1
    C2: TRUE as the word "footwear" in cell B2 is also found in cell A2
    C3: TRUE as the word "nike" in cell B3 is also found in cell A3
    C4: FAULSE as the neither the word "Fashion" nor "Sportswear" in cell B4 is found in cell A4.

    I'm struggling to find the right formula. I've looked a LOOKUP, VLOOKUP, SEARCH, FIND, etc. but not sure what I'm doing.
    One of the main issues is that in the URL column A the words are not separate to the rest of the text in the cell (i.e. they are surrounded by "http://www." & ".com" for example.

    Any help would be really appreciated.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Help finding text within a different cell

    Try this in C1

    Please Login or Register  to view this content.
    and copy down.

    Is this what you are trying to achieve?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    06-21-2014
    Location
    Brighton
    MS-Off Ver
    2011
    Posts
    115

    Re: Help finding text within a different cell

    Genius! Thanks you, would never have got that in a million years. Thanks a bunch!

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Help finding text within a different cell

    You're welcome. Thanks for the feedback.
    If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
    Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

  5. #5
    Forum Contributor
    Join Date
    06-21-2014
    Location
    Brighton
    MS-Off Ver
    2011
    Posts
    115

    Re: Help finding text within a different cell

    One last thing, as your obviously an expert!
    Is there a way to make that formula return the value of the word it matched rather than just true or false?

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Help finding text within a different cell

    Try this......

    Please Login or Register  to view this content.
    This will return A1 instead of True if any of two words from B1 is found in A1.
    I hope you are searching the keyword in B1 in A1 only, not in whole col. A.

+ 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. Need help with finding text in a cell.
    By n3xas in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2013, 11:25 PM
  2. finding text in cell
    By yog11spa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2013, 06:15 AM
  3. [SOLVED] Finding text in a cell
    By MrIdontknowexcel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-22-2012, 07:45 PM
  4. UDF for finding text in cell from a list of text
    By tom.hogan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2011, 10:14 AM
  5. Replies: 1
    Last Post: 01-11-2010, 12:31 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