Forum Discussion

johunt's avatar
johunt
New Member
9 years ago
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[...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    johunt

     

    Hi, Try with this:

     

    UK Region = IF(ISNUMBER(SEARCH("Region",Table1[Region],,BLANK())),"UK","International")

     

    Regards

     

    Victor

    Lima - Peru

johunt's avatar
johunt
New Member
9 years ago

Fantastic!  That worked!  Thank you so much

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

johunt,

 

You could use DAX below as well.

UK Region =
IF ( SEARCH ( "Region", Table1[Region],, 0 ) > 0, "UK", "International" )