Search specific word from paragraph and return the same value

M

mihir777

New member
Joined
May 28, 2016
Messages
24
Reaction score
0
Points
1
Excel Version(s)
2016
hello,

example is as below

Formula used =IF(SUMPRODUCT(--(NOT(ISERR(SEARCH($H$3:$H$5,E3)))))>0,"1","")

Current Result using formula
contentresult 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 sxx1 meet



expected result
contentresultspecific text
abc rohan fcv ssssb fff ssss eeeel fffll rohanraj
abc rbl fcv ssssb fff meet eeeel fffll meetrohan
raj ddd vvd ssdsd fdfee sxxrajmeet
 

Attachments

  • search.xlsx
    9.8 KB · Views: 5
In F9 copied down:

=IFERROR(LOOKUP(1000,SEARCH($H$9:$H$11,E9),$H$9:$H$11),"")
 
You must log in or register to reply here.
Back
Top