Weird! "*" doesn't work sometimes?

With the help of this page community, I created the following formula which let me compare individual items in a column against a large list of data elements in another column where more often than n...