Bulk Find Number from 2nd Sheet in 1st Sheet and copy value from same row to sheet 2

[adblog3]

Hello Friends,

I have a sheet 1 with 4000 records, and sheet 2 contains regular updates that we do.

I am looking to find cell value of Column A of Sheet 2 in Column M of Sheet 1 and if it is found then Copy Column B of Sheet 1 for the respective row in Column D of sheet 2.

Purpose: In the sample sheet below, Shipment No from 1st sheet has to matched with New Shipment No. in Sheet 2 for some manual verification.

Any help in this regard is highly appreciated.

[nankw83]

Does it have to be a macro ? This could be achieved in a very simple formula

Copy below formula in cell D2 in Sheet2
=INDEX(Sheet1!B:B,MATCH(A2,Sheet1!M:M))

[adblog3]

Yes Sir, need a macro to do the same, macro need to match the whole shipment no., as many many have duplicate partial numbers.

I have a large sheet with about 4000 rows, so i think a macro would be the best choice for the same, as i will need to do this operation everyday.

Does it have to be a macro ? This could be achieved in a very simple formula

Copy below formula in cell D2 in Sheet2
=INDEX(Sheet1!B:B,MATCH(A2,Sheet1!M:M))

[nankw83]

While I believe a formula could yield the same results but try the below macro as per your request

Please Login or Register  to view this content.

[sintek]

So why not just use nankw83 formula code as macro...

Please Login or Register  to view this content.

[adblog3]

Thank you kind Sir, it works perfect. Much appreciated.

While I believe a formula could yield the same results but try the below macro as per your request

Please Login or Register  to view this content.

[nankw83]

Glad to help & you are welcome

Please mark this thread as solved by selecting Thread Tools from the menu link above & add to the reputation(s) of those who helped

[adblog3]

Thank you very much Sir.

So why not just use nankw83 formula code as macro...

Please Login or Register  to view this content.