I have a column which has unstructured text - for example, a message from someone asking help in their own words.
I would like to match a row from another table based on one or more keywords.
In this table, there column with a drop-down list, if one or more of the items in the drop down list are present in the search text, then it should return that row.
I'm trying this out with has and contains, but can't seem to get it to match. To test, I've created a table with a single drop-down list column that I'm matching on the same row, the plan is once this is working, to wrap in collect / index / match type functions and reference another table.
But not getting the basics working yet.
HAS( [drop down]@row, contains(@cell,[search string]@row ))
I am expecting that if [search string]@row has at least one item from [drop down]@row then it should return true, otherwise false. But I only ever get a false return.
Is there any way to do this?
Ultimate objective is to pull through a value from a lookup table based on a match like this.