Macro If value Match copy row and paste to Match Value

Dear Members,

I have two sheets sheet 1 and sheet 2

I need Macro for

when sheet1 A column value Match with sheet 2 colmun A

then matched cell's all row range (B:D) copy to sheet 2 (F:G )

Please do the need ful

Hi, I am not sure if I understand your request. Do you need to copy the info on cells B:D (Sheet1) on Sheet2 (E:G), for equivalent item codes? If this is the case, the function VLOOKUP should work. See the file attached. Hope it helps!