Formula to find a string

Copper Contributor

Jun 22, 2022

Oddly, when I change the case from TRUE to True and FALSE to False, formulas 3 and 5 work!!! Thank you so much for your help!!

These two worked for me:

IF(ISNUMBER(SEARCH("Appointment of Rep",A2)),"True","False")

IF(COUNTIF(A2,"*Appointment of Rep*"),"True","False")

ISSU_DS	IF(ISNUMBER(SEARCH("Appointment*Rep",AD,0)),"True","False")	IF(ISNUMBER(FIND("Appointment of Rep",AD,0)),"True","False")	IF(ISNUMBER(SEARCH("Appointment of Rep",A2)),"True","False")	IF(ISNUMBER(FIND("Appointment of Rep",A2)),"True","False")	IF(COUNTIF(A2,"Appointment of Rep"),"True","False")	IF(COUNTIF(A2,"Appointment of Rep"),"TRUE","FALSE")
BENEFITS,SPECIALTY CARE,DENIED,CARE/SERVICE AVAILABLE WITHIN PROGRAM	False	False	False	False	False	FALSE
BENEFITS,DME,DENIED,DOES NOT MEET CRITERIA	False	False	False	False	False	FALSE
ACCESS,SURGERY/PROCEDURE,APPROVED,AUTHORIZATION CONFIRMED	False	False	False	False	False	FALSE
BENEFITS,DME,DENIED,DOES NOT MEET CRITERIA	False	False	False	False	False	FALSE
BENEFITS,DME,DENIED,NOT COVERED BY BENEFIT	False	False	False	False	False	FALSE
BENEFITS,DME,APPROVED,AUTHORIZATION CONFIRMED	False	False	False	False	False	FALSE
BENEFITS,RADIOLOGY,DISMISSED,EFFECTUATED PRIOR TO RECEIPT	False	False	False	False	False	FALSE
BENEFITS,NUTRITION/DIETICIAN,DENIED,NOT COVERED BY BENEFIT	False	False	False	False	False	FALSE
BENEFITS,DME,APPROVED,MEETS CRITERIA	False	False	False	False	False	FALSE
BENEFITS,DME,DENIED,DOES NOT MEET CRITERIA	False	False	False	False	False	FALSE
BENEFITS,DME,DENIED,CARE/SERVICE NOT MEDICALLY INDICATED	False	False	False	False	False	FALSE
BENEFITS,SPECIALTY CARE,DISMISSED,PRE TO POST	False	False	False	False	False	FALSE
ACCESS,DME,DENIED,NOT COVERED BY BENEFIT	False	False	False	False	False	FALSE
BENEFITS,DME,DENIED,CARE/SERVICE NOT MEDICALLY INDICATED	False	False	False	False	False	FALSE
BENEFITS,DME,DENIED,DOES NOT MEET CRITERIA	False	False	False	False	False	FALSE
BENEFITS,ALTERNATIVE CARE,APPROVED,AUTHORIZATION CONFIRMED	False	False	False	False	False	FALSE
BENEFITS,DME,DENIED,NOT COVERED BY BENEFIT	False	False	False	False	False	FALSE
ACCESS,SPECIALTY CARE,APPROVED,MEETS CRITERIA	False	False	False	False	False	FALSE
BENEFITS,DME,APPROVED,MEETS CRITERIA	False	False	False	False	False	FALSE
BENEFITS,DME,DENIED,CARE/SERVICE NOT MEDICALLY INDICATED	False	False	False	False	False	FALSE
BENEFITS,RADIOLOGY,APPROVED,CARE/SERVICE IS MEDICALLY INDICATED	False	False	False	False	False	FALSE
QUALITY OF CARE,SECOND OPINION/CONSULT,DENIED,CARE/SERVICE NOT MEDICALLY INDICATED	False	False	False	False	False	FALSE
BENEFITS,DME,DISMISSED,NO APPOINTMENT OF REP	False	False	True	False	True	FALSE
QUALITY OF CARE,RADIOLOGY,DENIED,CARE/SERVICE NOT MEDICALLY INDICATED	False	False	False	False	False	FALSE
BENEFITS,DME,DENIED,NOT COVERED BY BENEFIT	False	False	False	False	False	FALSE
BENEFITS,MENTAL HEALTH,DISMISSED,NO APPOINTMENT OF REP	False	False	True	False	True	FALSE

Forum Discussion

Resources