Categorize text with keywords

[wsgray]

Hello,

I am attempting to use a formula that will search for key words in text fields of cells and return the appropriate category>

[TABLE="width: 1097"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]=INDEX(CATEGORIES,MATCH(TRUE,ISNUMBER(SEARCH(KEYWORDS,A2)),1))

I am using this formula. But keep getting an #NA.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1097"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Subject[/TD]
[TD]CATEGORY[/TD]
[/TR]
[TR]
[TD]Adriana needs to confirmation if there is an issue with her laptop as the attendee are unable to hear her if she joins audio using VoIP[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Customer wants to reactivate his host account as it got deactivated[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Customer stated that unable to add the webex chrome extension[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Customer is unable to login as the site was disabled[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]customer wants to add contacts in the webex account she has and needs assistance[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Pls. change my current Webex account from Kathry.A.McSwain@kp.org to my old KP e-mail:mandy.mcswain@kp.org[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Customer wants to reactivate her webex host account[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Sam wants assistance to start the meeting has a Host[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Customer wants to change the name which is displayed in the email invite[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Joey wants to unlock the account and reset password[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Customer want to know why first person join meeting become presenter option is no longer available[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Customer is unable to start/join a WebEx meeting.[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Unable to login to the account[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Customer wants to re-activate his account.[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Kimberly called in reporting an issue where unable to login to account, it says your account has been closed.[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD]Edward called in reporting an issue where unable to login, it says Account deactivated.


[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]
This are my defined name cells: [TABLE="width: 222"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Keywords[/TD]
[TD]Categories[/TD]
[/TR]
[TR]
[TD]Activate[/TD]
[TD]Activate Account[/TD]
[/TR]
[TR]
[TD]Login[/TD]
[TD]Unable to login[/TD]
[/TR]
[TR]
[TD]Deactivate[/TD]
[TD]Deactivate Account[/TD]
[/TR]
[TR]
[TD]access[/TD]
[TD]Access Account[/TD]
[/TR]
[TR]
[TD]Recording[/TD]
[TD]Access Recording[/TD]
[/TR]
[TR]
[TD]Chrome[/TD]
[TD]Chrome Add-On[/TD]
[/TR]
[TR]
[TD]reactivate[/TD]
[TD]Reactivate Account[/TD]
[/TR]
[TR]
[TD]VoIP[/TD]
[TD]VOIP[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Try...

=LOOKUP(9.99999999999999E+307,SEARCH(" "&KEYWORDS&" "," "&$A2),CATEGORIES)

 

[wsgray]

Awesome Aladin! That did the trick. Will study up on "Lookup" command.

 

[Aladin Akyurek]

Awesome Aladin! That did the trick. Will study up on "Lookup" command.

Great. Thanks for the update.