SUMPRODUCT - Extract Exact Match or First Instance

[mmmarks]

Dear Team,

I m struggling to get desire out put as SUMPRODUCT is summing up matched values and going beyond the range. How we can fix it.

I have a column called "Subject Line " , In this column, I will have data (Note : Not maintaining any pattern)
I have to categorize them based on Certain Keywords : I prepared a list of Key Words (List2)
If any key word exist in subject line , I would like to bring that in another column called " Category"

Now, It is giving Ref# Error as its summing up all keywords and going out of the Range
Plus, It is not finding exact match also. That would be great If it is do exact match.

I placed image here for your reference .

Thank you for your time.

 

[Peter_SSs]

Does this do what you want?

22 10 18.xlsm
	C	D	E	F	G
1
2
3	Server Access			Server Went Down	Server Went Down Not accessible
4	Server Backup			Server Backup	Take Server backup
5	Server Went Down
6	Server Start
Category

Cell Formulas
Range	Formula
F3:F4	F3	=LOOKUP(9^9,SEARCH(C$3:C$6,G3),C$3:C$6)

If not, can you provide more sample data and expected results with XL2BB so that we can easily copy to test? (We cannot copy from an image )