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(...
Natas20075 , that is like
=IFERROR(IF(SUM(--ISNUMBER(SEARCH({"P3","P2","P1"},AE50))),"P3",FALSE),"")
SergeiBaklan, that work fine, except is there a way I can see the one that find? for now with the formula I put ("P3", False) if that working, but can it be possible that just put P2 or P1 by Excel himself or I need to every time replace the "P3" for the one I need to see?
