Forum Discussion
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(...
Hi Karthickrichard,
no that only showing False everytime, no able to see which P it is.
no that only showing False everytime, no able to see which P it is.
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 ^=^
Natas20075 , I'd only use SEARCH instead of FIND - the latest is case sensitive, don't think that's critical for you.
SergeiBaklan, no exacte, I change it to "Search" anyway because I got one cell where I need to find Word like "meet" so better "Search" as is non-sensitive. but that work just fine, thank you again for your help
