Lookup matched string in ListA in a sentence (in a cell), Return result from ListB

Hye Excel Experts,

I have these namedranges : ListA and ListB

PHRASE	CATEGORY
insufficient	Insufficient Balance
sufficient	Insufficient Balance
no balance	Insufficient Balance
missing	Missing Profile
not found	Missing Profile
not recognized	Missing Profile
login error	System Error
halt	System Error
corrupted	System Error

ListA is those data under header "PHRASE" while ListB is those data under header "CATEGORY".

I am trying to categorize the below error descriptions, whereby in every cell, there is a bunch of strings. I need to find the phrase in ListA that matches (no case sensitive) in that bunch of strings and return me the CATEGORY from ListB. Is there any anyone can help me with the formula, pls?

ERROR DESCRIPTIONS	PHRASE (Expected)	CATEGORY (Expected)
Your account doesn't have insufficient balance.	insufficient	Insufficient Balance
This account has no balance	No balance	Insufficient Balance
Details of this are missing.	missing	Missing Profile
System is facing login error.	login error	System Error
Customer's balance is not sufficient.	sufficient	Insufficient Balance
Red Alert! Halt Error!	halt	System Error
The processed file is corrupted.	corrupted	System Error
The corrupted config file will be deleted.	corrupted	System Error
Cannot found customer's profile	not found	Missing Profile

I have tried something like below formula but the result is wrong. Please help.

=IF(SUMPRODUCT(--ISNUMBER(SEARCH(ListA,$E2)))>0,ListB,"Others")

Thanks in advance.
DZ

Please find.

Sorry for sheet name

Originally Posted by shivya

Please find.

Sorry for sheet name

WoW!! You've done MAGIC! tqvm!!

To utilize this in future, may I know what actually 2^15 represents, please?

Again, thank you so much for the magic and fast formula!

DZ

Originally Posted by shivya

2^15 is a random number, if you don't know what you are looking for then you can use this type of series

Awesome!! Thanks a bunch Shivya! You saved my day!