Hello,
I am attempting to use a formula that will search for key words in text fields of cells and return the appropriate category>
<colgroup><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col></colgroup><tbody>
</tbody>This are my defined name cells:
<colgroup><col><col></colgroup><tbody>
</tbody>
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>
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>