I need help with a formula. I have attached a spread sheet. the formula is looking for specific text and if it has it in the cell then is should return a "Yes" otherwise a "No". I'm finding that sometimes I am getting a false positive and it says "Yes" when it should be a "No"
Here are the two formulas
=IF(ISNUMBER(SEARCH("COB*P*MA",C23)),"Yes","No")
=IF(ISNUMBER(SEARCH("COB*P*MB",C23)),"Yes","No")
Here is a sample of the data (each cell varies)
DMG*D8*19521108*M~HD*030**HMO*SEGIP~DTP*348*D8*20210701~COB*S*MA*1~DTP*344*D8*20171101~NM1*IN*2*MEDICARE PART A~COB*S*MB*1~DTP*344*D8*20171101~NM1*IN*2*MEDICARE PART B~
I have highlighted a couple cells that are returning wrong results. Cells B36 and B53. My concern is I have the same problem in column A as well just not spotting them.
Thank you
Bookmarks