Formula for looking up keywords and entering text in another column if a certain keyword is found.

[utrolig]

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:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Keyword[/TD]
[TD]Categorization[/TD]
[/TR]
[TR]
[TD]Java[/TD]
[TD]Java[/TD]
[/TR]
[TR]
[TD].jnlp[/TD]
[TD]Java[/TD]
[/TR]
[TR]
[TD]Password[/TD]
[TD]Password[/TD]
[/TR]
</tbody>[/TABLE]

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

 

[Aladin Akyurek]

Thank you!

You are welcome.