Finding value from cells in one sheet in second sheet where cells contain multiple values

[cob2021]

Hi,

I've tried what feels like everything to extract some values in a column in one worksheet where the cells contain more than just the values i am looking for, from a column in a second worksheet- each column contains thousands of rows.

Here is an example of what i need to do:

Sheet one cells
1122334455
1234554321

Sheet two cells
1234-mat ref 1122334455
mat 4321 1234554321

I want to be able to search for the values in sheet one, in sheet two and either extract the values it finds, or return a Yes (or anything).

Is this possible?

Thanks in advance

 

[Fluff]

Glad we could help & thanks for the feedback.