Formula to find a specific word

  • Hi


    Is there a formula to find a specific word through many columns?
    Between A1 and L4500 i got a lot of diffrent information. I want to show if there is any cells in the row with the specific text, a formula in column M.
    Etc. If C100 got "topside" a notice in column M


    Appreciate all help!

  • Re: Formula to find parentheses


    I tried =IF(ISERROR(SEARCH("Text",A5)),0,1)
    But this formula didnt allow me to search throught more than one cell.
    Etc.
    =IF(ISERROR(SEARCH("Text",A5:L5)),0,1)


    Maybe I just need a minor change, but i don't know.


    Thank you

  • Re: Formula to find parentheses


    Can you post a sample workbook showing examples of what you have and want?

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Re: Formula to find a specific word


    Maybe you mean?


    =--(COUNTIF(A2:K2,"Topside")>0)


    copied down?

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!