Searching for mulitple criterea in an unstructered cell

Hello people,

english isn't my first language so I apologize in advance if my description of the issue isn't the best or I don't use the proper terminology.

Problem

Here is what I'm hoping to achieve. I'm trying to match entries based on partial contents of the cells with mulitple criterea. For example in the picture in column F ' Text'. There are mulitple different things contained in it, in no set order. But every entry in column F contains either the reference in column A oder the casenumber in column B, or sometimes both. For the data in columns A, B and C I can say that the row is always matched, so a row always belongs together. I have been trying to give out the name in column C into column F with VLookup, so that Smith would show up in F2, Park F3, Smith F4, Smith F5, and Miller F6

I have been unsuccesful so far trying to use partial matches or filter for character lenght, but nothing I could find seems to be suitable for this situation. I have googled a lot and watched a few dozen videos but didn't find a solution, but maybe I have not been looking for the right things.

I hope someone can help me with a formula or method this can be achieved.

Thanks in advance!