Macro to match part number and serial numbers

Hello,

This is my first post on this forum so please excuse any errors or shortcomings. I am attempting to create a load file for an aircraft engine. The engine consists of roughly 950 part number but I am only concerned with 94 of those part numbers.

I am asking for assistance creating a macro that would match the part numbers in two columns (B) & (AL) and determine if the 94 parts numbers found in (B) are found in (AL).

IF the part number from (B) is found in (AL), then return the corresponding serial number (AM) into column (C). I've been able to create a macro for the first match: =ISNUMBER(MATCH(B2,AL:AL,0))

Help with this would be of tremendous help! I've attached a snip of the excel file I am using.

Respectfully,

Derrik Bowen