I've checked around the forum and haven't been able to find a solution that matches what I need (at least using the examples given thus far). I have a text field where users have historically been able to type whatever they want. In converting to a new system, we have a list of available keywords which will be used in a drop down. For the conversion, we want to return each keyword contained in the text field, ideally with comma separation.
I am attaching the following spreadsheet. The Injuries sheet contains examples of text entered. I have included a highlighted column using the formula below. I have then created a manual 3rd column which has my desired results. So far, with the formula below, I can only get it to return one keyword value based on the Keywords tab. It appears it is always pulling the last available one in that list if there are multiple.
=IFERROR(LOOKUP(1E+100,SEARCH(Keywords!$A$2:$A$92,A290),Keywords!$A$2:$A$92),"")
Bookmarks