Forum Discussion
Solved
Error in FIND/SEARCH function
I keep getting the following error The search Text provided to function 'SEARCH' could not be found in the given text. when i put in this formula UK Region = IF(ISNUMBER(SEARCH("region",Table1[...
Can you change your formula to IF(ISTEXT(SEARCH.........)
UK Region = IF(ISTEXT(SEARCH("Region",Table1[Region ])),"UK", "International")
The search Text provided to function 'SEARCH' could not be found in the given text.
Hi there
Changed it, but still the same error... pic attached ...
Hi, Try with this:
UK Region = IF(ISNUMBER(SEARCH("Region",Table1[Region],,BLANK())),"UK","International")Regards
Victor
Lima - Peru
Fantastic! That worked! Thank you so much
You could use DAX below as well.
UK Region = IF ( SEARCH ( "Region", Table1[Region],, 0 ) > 0, "UK", "International" )
Cool; I had the same issue and it works. Thank you!
