Forum Discussion
Solved
Search for text within a string - make dynamic
Hi,
I want to search for a particular word in a column within the table.
I want to be able to pass in the search word as a variable value, so can make this dynamic, can it be done?
My code currently looks like this:
SearchForString = IF(
ISERROR(
SEARCH("Word", 'Table'[Column)
),
"No Match","Match"
)
