Consulting

Results 1 to 2 of 2

Thread: Ifnumber & Search with mulitple Conditions

  1. #1
    VBAX Regular
    Joined
    Jan 2018
    Posts
    32
    Location

    Ifnumber & Search with mulitple Conditions

    Dear Friends ,

    Could anyone please help with the below Formula

    =IFERROR(IF(SEARCH("*CITATION*",Q2,1),"CITE"),"Core"+=IFERROR(IF(SEARCH("*A PPROVAL*",Q2,1),"APPROVED"),"Core"+=IFERROR(IF(SEARCH("*INVITATION*",E2,1), "INVITE"),"Core"

    i wanted to convert this in multiple condition and in different columns too , is it possible

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    Cross posted at at least 2 other sites.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •