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

Hasan's avatar
Hasan
Resolver I
9 years ago

Can you change your formula to IF(ISTEXT(SEARCH.........)

  • johunt's avatar
    johunt
    New Member
    9 years ago

    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 ...

     

     

     

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      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