Forum Discussion

Natas20075's avatar
Natas20075
Copper Contributor
Apr 17, 2019

Need Help on Formule SEARCH

Hi, I'm a new user from Excel software and I try to make a Formule that will help me to Search a specific text and show which one found from a comment text here the one I made for now: =IFERROR(IF(...
excel
Formulas and Functions
karthickrichard's avatar
karthickrichard
Copper Contributor
Apr 17, 2019

Natas20075 You can try this formula.

 

=IFERROR(IFS(ISNUMBER(SEARCH("P1",AE50,1)),"P1",ISNUMBER(SEARCH("P2",AE50,1)),"P2",ISNUMBER(SEARCH("P3",AE50,1)),"P3"),"FALSE")

  • Natas20075's avatar
    Natas20075
    Copper Contributor
    Apr 17, 2019
    Hi Karthickrichard,
    no that only showing False everytime, no able to see which P it is.
    • Natas20075's avatar
      Natas20075
      Copper Contributor
      Apr 17, 2019

      Thanks to both of you I think I find it:

      =IF(ISNUMBER(FIND("P3",AE7,1)),"P3",IF(ISNUMBER(FIND("P2",AE7,1)),"P2",IF(ISNUMBER(FIND("P1",AE7,1)),"P1")))

      that look and write the exact P# that found

      I really appreciate that you answer that fast

       

      have a good day ^=^

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 17, 2019

        Natas20075 , I'd only use SEARCH instead of FIND - the latest is case sensitive, don't think that's critical for you.

Resources