Function To enter A value in one column based on description word in another column

Hello!
I have a workbook that contains a column of “Operation Descriptions”, and a column that needs to indicate in which department to perform those operations. I have a separate list of specific descriptive words that help identify which department to use, but they are not always the first word in the operation description.
I need a function string that I can use to place the correct department number into the “Dept” column, based on the operation description column.
It seems like it will be a long function string, so if you could just start me in the correct direction, I probably can follow a pattern to make it complete. I’m just not sure which function to use.
Thanks for any help you can give me!

Hello! I've changed the file locations in the formula to match the file location on my desktop, but the formula is still returning "#Value". Any suggestions?

Both the files should be in same folder.In case still problem is there upload similar files with Dummy data.