Hi guys!
I need a formula or a script which will check a if a cell contains keywords from a list in another sheet.
If a keyword is found, it will populate the cell next to it with the "category" set for that keyword.
So I have a sheet which is called "Keywords" which contains the keywords to look for, and the categorization for each keyword.
Example:
<tbody>
</tbody>
So basically what I want is a formula that can check "A1" if the cell contains any of the keywords from the "Keywords" sheet, and if it does - populate "B1" with the corresponding categorization depending on what keyword was found.
Is this even possible in Excel?
Kind regards,
utrolig
I need a formula or a script which will check a if a cell contains keywords from a list in another sheet.
If a keyword is found, it will populate the cell next to it with the "category" set for that keyword.
So I have a sheet which is called "Keywords" which contains the keywords to look for, and the categorization for each keyword.
Example:
Keyword | Categorization |
Java | Java |
.jnlp | Java |
Password | Password |
<tbody>
</tbody>
So basically what I want is a formula that can check "A1" if the cell contains any of the keywords from the "Keywords" sheet, and if it does - populate "B1" with the corresponding categorization depending on what keyword was found.
Is this even possible in Excel?
Kind regards,
utrolig
Last edited: