Find A Number With a Cell That Could Contain Other Characters - Looking Up Another Tab

[TkdKidSnake]

Hi,

I'm really struggling here, I am trying to find particular number sequences in a column and if the number matches on another tab to then report "Yes" and if there isn't a match to return "No" however, there could be other characters within the same cell.

What I have currently is:

=ISNUMBER(SEARCH(Validation!D:D,'CAFM Data'!X:X))

This looked to have worked with reporting True or False however, it also return some results as True where there was only text and this did not appear on the Validation tab at all.

So I have a list of numbers on the Validation tab where I am looking up against the CAFM Data sheet to see if a group of numbers in the correct sequence appears anywhere in the cell.

CAFM Data

Validation

Any idea anyone.

Any help would be greatly appreciated.

Thanks in advance.

 

[TkdKidSnake]

This picture is better as it shows other characters in the CAFM Data