Hi Experts,
I have been having issue of resolving the above mentioned.
Attached is the sample file.
1. I was figuring on how to search keywords on the Resolution column and then return a category matching the keywords based on the array created in "Keywords" tab.
For eg, If the keyword reset is found in the Resolution Column, the formula would search in the Keywords column and return the categories tag to Reset which is Password Reset.
2. I am not sure if the formula can be expanded to work around this.
=IF(SUM(COUNTIF(O2,{"*adapt*","*batt*","*cable*","*cartridge*","*LEGACY LAN*","*network*","*Patching*","*switch*","*dock*","*Print*","*domain*","*drum*","*fan*","*faulty*","*Bitlocker*","*TPM*","*recovery code*","*Remediat*","*mediat*","*recovery*","*jam*","*MB*","*mother*","*NCS*","*NIC*","*charge*","*refix*","*power unit*","*port*","*button*","*spacebar*","*fix*","*Commserve*","*noise*","*hard*","*flicker*","*replace*","*fuser*","*mark*","*dirty*","*smudge*","*kit*","*maintenance kit*","*toner*","*Paper Jam*","*vendor*","*Xerox*","*screen replace*"}))>0,"Break-Fix")))
Thank you all in advance for your help.
Best regards,
Shad
Bookmarks