+ Reply to Thread
Results 1 to 2 of 2

Find Text Within A String

  1. #1
    Registered User
    Join Date
    10-24-2010
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    49

    Find Text Within A String

    I am using the following formula to Find Text within a String using a Named List.

    =ISNUMBER(MATCH(TRUE,ISNUMBER(SEARCH(Names,E2)),0))

    Unfortunately the Formula only returns a value of True or False.

    How can I modify the Formula to return the Text in the Named List.

    Thank you.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Find Text Within A String

    I am not sure that I can meet your idea, but may be, for example:
    List of Names: in A1:A3
    Search each Names in string in E2, if matching returns Names.
    If it is correct, try this:
    =LOOKUP(10^10,SEARCH(A1:A3,E2),A1:A3)
    Hope this helps.
    Quang PT

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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