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","")
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 |