Combine and Compare two Lists

Hello,

I'm trying to compare and combine two lists together. I have two worksheets with two columns each. Worksheet 1 column A is a list of devices. Column B is a list of names associated with those devices. On worksheet 2, column A is a more-encompasing list of devices that overlaps column A from the first worksheet. Column B is also a list of names that is longer and more encompasing than column B.

Column B in worksheet 1 is empty, and needs to be populated from worksheet 2. But since worksheet 2 has so much more data in it, I'm not sure how to compare and combine them without doing it one at a time..

Sorry if this is a totally novice quesiton, I found some VBA code on comparing lists but nothing I have tried has worked so far.

Thanks.

The data in column A of both sheets is alpha numeric and contains dahes (-), spaces, and is always less than 20 characters. The data in column B is also alpha numeric and contains dashes as well as this symbol " | ", spaces, and can be up to 60 characters.

Example data in column A:
TYDIX-4780A
SAPSLDZ-7599-928B
GRDOLP1
VMCS87997

Example data in column B:
Voice
CORE-SERVICE | 555-5555
SUPPORT EX | 555-5555

The second worksheet is the same as far as what the data looks like, there are just many many more entries, around 1100 compared to 200 in the first worksheet.