Macro to match part number and serial numbers

[Dbowen74]

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

[jolivanes]

Instead of a picture (macros are very difficult to try on a picture), attach a short version of your actual workbook with preferably before and afters.

[Fluff13]

You can do that with a formula, not need for VBA.

=INDEX(AL$2:AM$100,MATCH(B2,AL$2:AL$100,0),1)

[Dbowen74]

Hello folks,

A copy of the workbook is attached. Thank you!

Derrik Bowen

[Fluff13]

How about
=IFERROR(INDEX(AL$2:AM$305,MATCH(B4,AL$2:AL$305,0),1),"Not found")

[Dbowen74]

Hello Fluff13,

Thank you very much for your response! The formula did not return the desired result as the serial numbers (if found) from (AM) did not populate (C). I am pasting the formula into column (A), is that correct?

Derrik Bowen

[Fluff13]

It needs to go in C2 & fill down.

[Dbowen74]

Hello again,

=IFERROR(INDEX(AL$2:AM$305,MATCH(B4,AL$2:AL$305,0),1),"Not found") is not returning the desired result when pasted into column (A) or (C). Thank you!

Derrik Bowen

[Dbowen74]

When pasted into C2, part numbers populate column C incorrectly

Derrik Bowen

[Fluff13]

Oops, typo in the formula, it should be
=IFERROR(INDEX(AL$2:AM$305,MATCH(B2,AL$2:AL$305,0),2),"Not found")

[Dbowen74]

BOOM THERE IS IT! THANK YOU! I cannot express how helpful your time was today

Derrik Bowen

[Fluff13]

Glad to help & thanks for the feedback