need help in replacing text

[faddies]

hi

I need a formula that find the word given in column E, from column A
and replace it with the given category in column F.
I want each word to convert into its category given in E and F column
currently I am doing ctrl+h and replace each word one by one
can any one help me to suggest me any formula to do so ?


please see the attached file for more explanation