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