Results 1 to 4 of 4

Search within text and IF solution needed

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2011
    Location
    arizona
    MS-Off Ver
    Excel 2007
    Posts
    2

    Search within text and IF solution needed

    Hello,

    First post here.

    I help and I'm hoping someone out there has an answer. Probably simple for a lot of you.

    I need to search within the text of a cell and output a certain value in the cell next to it.

    I'm currently using this: =IF(SEARCH("*1629*",A1,1),"1629","") but I need to serach for multiple values.

    I've attached an example. Row 1 has the result I need using the formula. Row 2 and 3 show the value I need and how it should look, but I just put the values there manually.

    A B
    cat dog xyz def ghi lakers suck "1629 1629
    apple tree house fly Lebron sucks too "1633" 1633
    it is hot in arizona "1655" really hot 1655


    thanks
    Attached Files Attached Files

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