How to check if numbers contained in a cell are also in another cell (or a better method)

Hi all

I have a spreadsheet like the below, where I am trying to figure out if the values in column B are contained in their corresponding cell in column A. I am using the following formula in column C:

=IF(ISNUMBER(SEARCH(B2,A2,1)),"Pass","Fail")

ContainedInCells_Test.JPG

The problem is with row 3, which should have a Pass Status. Even though the full text string in B isn't contained in A, the actual numbered categories are.

I am trying (if possible) to avoid any long-winded splitty windey way to achieve this, and my vaguest thought is if I can check by 3 digit number values between the two cells somehow. All values are consistent in that they are a three digit number, and then a dash, and then the text.

Is it possible to do something like this, or would there be another relatively simple way?

Thanks!

Oh wow - that works perfectly!! Thank you so much! Do you mind walking me through it?

Hi again. Unfortunately, where there are more than three categories "on the shelf", this doesn't seem to pick up on them (now the shop sells colours).

ContainedInCells_Test2.JPG

Here, it passed, even through the second two categories are not "in the shop. There could be anything up to 30 categories unfortunately.