pratheesh1983
Board Regular
- Joined
- Aug 13, 2015
- Messages
- 55
- Office Version
- 365
- Platform
- Windows
We have a set of key words and I'm looking for a formula which will the highlight (showing the keyword) if any of the key word is available in a text string on a cell.
eg. Table 1 have two columns - "Text" Column consists of multiple words & in column "Key Word Available" were we need to put a formula which will look for the Keywords mentioned in Table 2 in in column Text cells and will populate the keywords if it's available if not it will show the result as "N/A"
Could any one please help in formatting a formula here?
Table 1
Table 2
eg. Table 1 have two columns - "Text" Column consists of multiple words & in column "Key Word Available" were we need to put a formula which will look for the Keywords mentioned in Table 2 in in column Text cells and will populate the keywords if it's available if not it will show the result as "N/A"
Could any one please help in formatting a formula here?
Table 1
Text | Key Word Available |
Adjust audio settings according through lancable | audio; lancable |
external monitor with a closedlaptop | monitor; laptop |
How Do I Keep The Display On | N/A |
This article will show you how to be able to keep using laptop or MacBook | article; laptop |
You can now close your laptop lid | laptop |
Table 2
Key Words |
Audio |
RAM |
Lan Cable |
Article |
monitor |
Laptop |