Thread: Search Multiple Strings and if Present get single word as output
View Single Post
 
Old 05-17-2019, 08:48 AM
transactions transactions is offline Windows 7 64bit Office 2013
Novice
  
Join Date: May 2019
Posts: 1
transactions is on a distinguished road
Default Search Multiple Strings and if Present get single word as output
Hey I am thinking about creating an excel which would analyse a press release and would search with different strings and if the string is present than it would give a single word as out put

example - if the terms - "Board" and " Approved" are present in A1 (Press release) then in A2 "Board Approval" should come. If terms "Legal" and "advisor" are present in the A1 (Press Release) then in A3 "Legal Advisor" should come. I have close to 20 such combinations (some with 2 words, some with 4 or more) and there output if present.

can some one please help me
Reply With Quote