well, maybe you'll know how to do it with the bigger picture. I'll give you
an ‎example: there is a textbox column that might contain the sentence "a box
of ‎chocolate". I have another column that needs to say what kind of candy
(from a ‎known list of possibly candy) it is the first column. now I need a
function that will ‎automatically finds which of the keywords is in the
textbox column and gives the ‎answer in the second column.‎