sg2209
01-14-2018, 07:42 AM
Dear Friends ,
Could anyone please help with the below Formula
=IFERROR(IF(SEARCH("*CITATION*",Q2,1),"CITE"),"Core"+=IFERROR(IF(SEARCH("*APPROVAL*",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
Could anyone please help with the below Formula
=IFERROR(IF(SEARCH("*CITATION*",Q2,1),"CITE"),"Core"+=IFERROR(IF(SEARCH("*APPROVAL*",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