VBA to find referenced cell contents and return adjacent cell

[Lazerus3511]

Greetings and salutations Mr.Excel folks.

First off, thank you all for being here and willing to help. I've used this forum for a great many other deeds in the past. I am not a VBA wizard, but I know my way around excel a fair bit.
Today I got a fun one that I feel jumps into the land of VBA.

The Scenario:
List 1 contains a list of Mac Addresses in column A and the user name in column B.

List 2 contains a list of ALL the Mac addresses of the computer, separated by a line break and in a single cell in column A. The Serial number of the Mac in column B.

I am finding I am having a very difficult time getting excel to Text to Columns because of the line break, otherwise this would be easy.
My next thought is, is there a way to write a VBA script to search for the Hardware Address in List 1, find that address in List 2 and return the adjacent serial number back to List 1 in column C?
then Loop until it goes through ~4,000 matches?

Figured I would toss this out here and see if any of ya'll wizards have something up your sleeve!
Thanks in advance!

 

[Z51]

In B2 on the 'List1' sheet, try:

=INDEX(Sheet2!B:B,MATCH("*"&A2&"*",Sheet2!A:A,0))

Adjust Sheet2 to the actual sheet name your "List 2" is on, and fill that down column B.

 

[Lazerus3511]

In B2 on the 'List1' sheet, try:

=INDEX(Sheet2!B:B,MATCH("*"&A2&"*",Sheet2!A:A,0))

Adjust Sheet2 to the actual sheet name your "List 2" is on, and fill that down column B.

@Z51, this worked absolutely flawlessly, I never thought to force a wildcard with & to a whole cell!
This is genuinely appreciated