Forum Discussion

ViorelCa's avatar
ViorelCa
Helper I
9 years ago
Solved

Error in FIND/SEARCH function

Dear Colleagues,   I have a column that stores emails, called [leadsemail].   And a Helper column, called [helper1], that extract the emails from the [leadsemail] column based on a condition:   ...
Need Help
  • Datatouille's avatar
    Datatouille
    9 years ago

    Hi ViorelCa

     

     

    You might have some elements in your helper1 column which do not have any "@" at all.

    In that case, Find() function returns an error and is not able to compute the correct calculation for any rows of your helper1 column - even those which actually include the symbol "@".

     

    If you add an IfError statement, you will get rid of this error:

    =IfError( Find ("@" , TableLeads[helper1] ) , 0 )

Datatouille's avatar
Datatouille
Solution Sage
9 years ago

Hi ViorelCa

 

 

You might have some elements in your helper1 column which do not have any "@" at all.

In that case, Find() function returns an error and is not able to compute the correct calculation for any rows of your helper1 column - even those which actually include the symbol "@".

 

If you add an IfError statement, you will get rid of this error:

=IfError( Find ("@" , TableLeads[helper1] ) , 0 )

ViorelCa's avatar
ViorelCa
Helper I
9 years ago

Dear Tristan Datatouille,

 

Your solution worked!

 

Many thanks for the help!

 

Kind regards,
Viorel