The string in F2 has a space at the end. The string in A260 does not. Therefore no match. If you do a find & replace on your entire sheet to eliminate all spaces, you will get 286 matches.

Parsing through multiple values in the same cell means either:
  • Additional "helper" columns that break out the values. The formula would be a little complicated because sometimes the separator is "," and sometimes it's "/" and sometimes it's both.
  • VBA code to do the whole thing.

I am better at VBA than I am at complicated formulas so that's where I would lean. Others might be better ideas.