• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Modify the results of the search equation

Hany ali

Active Member
Hello every one kindly assist me in modifying the research equation in the file
Code:
=IF(COUNTIF($AV$3:$AV$11,$M3)>0,"Shopping",IF(ISNUMBER(SEARCH({"*Discount*","*discount*","*CXL*","*cxl*"},X3)),X3,""))
Provided that the result is as explained in the file ... for example, if the sentence in any cell in column X is 10$ Discount AS PER MR.M.Zaid
So I want the result of the equation to be in the corresponding cell in column X only 10$ Discount Not all of this sentence is in column X
Thank you very much, and God bless you
 

Attachments

  • Search.xlsm
    22.8 KB · Views: 6
  • 1.png
    1.png
    35.3 KB · Views: 3
Try,

=IF(COUNTIF($AV$3:$AV$11,$M3),"Shopping",IF(ISNUMBER(SEARCH("discount",X3)),LEFT(X3,SEARCH("discount",X3)+7),""))

Regards
 
Last edited:
thanks alot for you... But else i Want To Get Cxl when in Column X , AS You See in This Photo
 

Attachments

  • Untitled.png
    Untitled.png
    27.7 KB · Views: 5
Maybe,

=IF(COUNTIF($AV$3:$AV$11,$M3),"Shopping",IF(OR(ISNUMBER(SEARCH({"discount","cxl"},X3))),IFERROR(LEFT(X3,SEARCH("discount",X3)+7),X3),""))

Regards
 
Back
Top