Cross referencing 2 Columns, but formula isn't properly working.

[j7house]

I am trying to cross-reference 2 columns. Column G has a list of Specialties and Column I is the column that needs to be checked if any of those terms are in Column G.

The formula I am using is =IF(OR(COUNTIF($G3,"*"&I3&"*")),"Match","No Match"). AS you can see in the screenshot you can see that there are matches and no matches. The very first instance shows in D2 but if you check both columns G & I; Column I does in fact have those terms in column G but shows to be a no match.

What am I missing or what am I not doing right?

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.

[Glenn Kennedy]

No reply... try this:

=LET(a,TEXTSPLIT(G2,","),b,TEXTSPLIT(I2,","),IF(--(SUM(--NOT(ISNA(MATCH(b,a,0))))=LEN(I2)-LEN(SUBSTITUTE(I2,",",""))+1)>0,"Match","No Match"))

[j7house]

This is giving me the same out puts as the original formula. There are instance where the cells have the same exact information in both columns but it is not counting it as a match, when it should be.

[Glenn Kennedy]

Then post a file showing the issue (as akready requested), as your last post doesn't narrow down the problem, at all.