+ Reply to Thread
Results 1 to 2 of 2

Help with finding text strings in other text strings.

  1. #1
    Registered User
    Join Date
    05-30-2011
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    9

    Help with finding text strings in other text strings.

    Hi,
    I am confident someone can help me solve the issue that is wrecking my head at the moment.

    I would like to be able to look for a piece of a text string which is in a specific cell in one workbook in a list which is held in another workbook.

    E.g. the following text "ESB" is held in cell A1 in Workbook A. I know that in the list in Workbook B there is "ESB International". I want to create a formula that looks for the text held in Workbook A, cell A1, in the list in Workbook B and returns the value "True" if it is there and "False" if it is not.

    I'm scrambling my brain with FIND MATCH VLOOKUP LOOKUP functions but have a feeling I am on the wrong track... really is it that hard to ask a formula in excel to take the string in one cell and look up in a list a SIMILAR but NOT exact match??

    I sure hope I am being clear with my request here and would be very grateful if anyone could help me out.

    Many thanks in advance
    G

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Help with finding text strings in other text strings.

    try
    =SUMPRODUCT(--(ISNUMBER(SEARCH(" "&A1&" "," "&[Book2]Sheet1!A2:A10&" "))))>0
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ 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