Results 1 to 3 of 3

Thread: Search specific word from paragraph and return the same value

  1. #1
    Acolyte mihir777's Avatar
    Join Date
    May 2016
    Posts
    23
    Articles
    0
    Excel Version
    2016

    Search specific word from paragraph and return the same value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hello,

    example is as below

    Formula used =IF(SUMPRODUCT(--(NOT(ISERR(SEARCH($H$3:$H$5,E3)))))>0,"1","")
    Current Result using formula
    content result specific text
    abc rohan fcv ssssb fff ssss eeeel fffll 1 raj
    abc rbl fcv ssssb fff meet eeeel fffll 1 rohan
    raj ddd vvd ssdsd fdfee sxx 1 meet


    expected result
    content result specific text
    abc rohan fcv ssssb fff ssss eeeel fffll rohan raj
    abc rbl fcv ssssb fff meet eeeel fffll meet rohan
    raj ddd vvd ssdsd fdfee sxx raj meet
    Attached Files Attached Files

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,710
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    In F9 copied down:

    =IFERROR(LOOKUP(1000,SEARCH($H$9:$H$11,E9),$H$9:$H$11),"")
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Acolyte mihir777's Avatar
    Join Date
    May 2016
    Posts
    23
    Articles
    0
    Excel Version
    2016
    Thanks worked

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •