Find a word that has synonyms, in a sentence, and replace it with another word (synonym)

I am trying to figure this one out and really need some help:

I need to search a cell (A2) to see if it contains one of the words from a list (C2:C5) if yes, then that word needs to be replaced with one of the other words in the list - randomly (or replaced with the same word).

I tryed alot of variations but my brain is melting. Can someone nudge in a right direction?

Excel example: https://ibb.co/gBdOw6

You cannot replace value in A2 but in B2


=IF(ISNUMBER(SEARCH($C$2:$C$5,A2)),INDEX($C$2:$C$5,RANDBETWEEN(1,4)),"")

This forum is AMAZING

Alkey thank you for the code and the detailed explanation! I get an error when i paste in your code: https://ibb.co/em75R6 - a value is missing. I do understand parts of it but I am too newbie to be able to debug this one

JohnTopley thank you alot for the reply.. your code returns a blanc cell - I wish I could figure out why, my self

Try

=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(C2:C5,A2)))),INDEX(C2:C5,RANDBETWEEN(1,4)))

or obviously use Alkey's!

Thanks Alkey! Downloading it an opening in my Excel, it works! - My Excel is not in English, so i testet et in my English Google Sheets and that's where the error came (I thought they worked the same way) - anyways, my Excel translated it to my language and there we go it works!.. thanks agin

Thanks for input John Topley

If this should work in Google Sheets, would you have to use some other function in another way?

Say i wanted to check even more synonyms. Could i just use the same funtion and "combine it 3 times"? How to combine this one?

Here is an example of what I mean - B2 is the outcome I am trying to accomplish.

example more variables.JPG

Please post a file not an image.

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you for instructions. I have made a project Google Sheet - I hope this will make it more easy --> https://docs.google.com/spreadsheets...it?usp=sharing

Thank you all for input - I am very pleased with all this help i get. +KARMA