How to create macros in Excel that scan data from second sheet

[Chini mao]

Hi friends recently I was trying to create the Excel macros so that I can solve this query, I have 2 sheets in the excel file. On the first sheet the first column is a part num only. The second sheet has part num on the first column and descriptions on the second column. I need a macro or script that will scan the second sheet for part num that matches the first sheet part num and populate the description (at the second column) on the first excel sheet. So if you guys have any information then please let me know. Your reply will be appreciated.

[Erakna]

According to my information there is One way that Assuming the reference data is in Sheet2, cols A and B, col A = part#, col B = description In Sheet1. With col A containing part# in A2 down, you have to Put in B2: =IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"",VLOOKUP(A2,She et2!A:B,2,0)) then you have to Copy down the Col B will return the descriptions corresponding to the part# in col A. Unmatched part#s will return blanks: ""