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>

=INDEX(CATEGORIES,MATCH(TRUE,ISNUMBER(SEARCH(KEYWORDS,A2)),1)) I am using this formula. But keep getting an #NA.

<colgroup><col><col></colgroup><tbody>
</tbody>

Subject	CATEGORY
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	#N/A
Customer wants to reactivate his host account as it got deactivated	#N/A
Customer stated that unable to add the webex chrome extension	#N/A
Customer is unable to login as the site was disabled	#N/A
customer wants to add contacts in the webex account she has and needs assistance	#N/A
Pls. change my current Webex account from Kathry.A.McSwain@kp.org to my old KP e-mail:mandy.mcswain@kp.org	#N/A
Customer wants to reactivate her webex host account	#N/A
Sam wants assistance to start the meeting has a Host	#N/A
Customer wants to change the name which is displayed in the email invite	#N/A
Joey wants to unlock the account and reset password	#N/A
Customer want to know why first person join meeting become presenter option is no longer available	#N/A
Customer is unable to start/join a WebEx meeting.	#N/A
Unable to login to the account	#N/A
Customer wants to re-activate his account.	#N/A
Kimberly called in reporting an issue where unable to login to account, it says your account has been closed.	#N/A
Edward called in reporting an issue where unable to login, it says Account deactivated.	#N/A

<colgroup><col><col></colgroup><tbody>
</tbody>

This are my defined name cells:

Keywords	Categories
Activate	Activate Account
Login	Unable to login
Deactivate	Deactivate Account
access	Access Account
Recording	Access Recording
Chrome	Chrome Add-On
reactivate	Reactivate Account
VoIP	VOIP

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[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.