I was searching for this formula since long. Thank you for sharing your knowledge and making my day. 🙂

You've saved me a lot of time with this. I'd been doing similar with the find or search function, but seemed to check only just the first word in my list. Appreciate the vid.

@InItLearning - This is really amazing! Solves a lot of my troubles! Question - What if I want to get the output as the exact first keyword found. In your case if I want the output to be word "Laptop" if found and blank if not found. Basically search for the keyword in the string and return the work "laptop" or "mobile" or whatever from a second table? Is that possible (without having to create separate columns for each keyword? Can you please let me know how to go about that?

Hey Mate! This formula work perfectly fine. Could we return value like the words with coma separated which are available in the data. Like in your case Laptop, Webcam instead of Yes and no. Thank you

Great Work Sir! ....................I have a question though If the word's found................... then how to replace the formula with that specific word instead of "Yes"/"No"

idk how, idk what i did, but it worked for my projectk, ty very much!

What if I want to get the output as the exact first keyword found. In your case if I want the output to be word "Laptop" if found and blank if not found. Please share the formula.

What a slay

doest work on my work