Excel Wildcard If statement for two columns?

I'm not sure what excel function to use.

I have two columns 'asset tag' and 'computer name'. Both unique values. The asset tag has a name like '11111' the computer name has a name like 'AA-11111-BB'.

I need a formula to output every asset that is also in the computer name column into its own column.

As you see the asset tags name is inside the computer name between characters.

I don't know how to tie these two columns together when their names are not exactly the same.

IS the a wildcard if statement formula for two columns to accomplish this. Please see my screenshot as well.