Hi, I have two spreadsheets.

Spreadsheet #1 has 2 columns Asset/MAC:
Asset MAC
12345 00004
53482 00005
24352 00004
44432 00034

Spreadsheet #2 has 2 columns Asset/Code:
Asset Code
12345 ABCD
44432 EFGH
934752 REUJ

I want to pull the data from the Code Column of spreadsheet #2 into Spreadsheet #1.

How would I do this in excel?