Seach for data from one sheet to another sheet and copy past adjacent columns

Hey Guys,

I am sure this would be very easy for most of you but this is killing me.

I have this file with two sheets. Sheet 2 is static data and Sheet 1 will be variable data and will keep changing each week.

So what I want to do is to go through each cell in Sheet 2 row A and find that code in Sheet 1(could be anywhere in the sheet1) and then copy the two adjacent column values in sheet 1 next to the code and paste it on sheet 2.

For example, the code should go to Sheet 2 column A, first cell 12362 and then look for this code in sheet 1 and copy the value 101 and 102 and paste it in sheet 2 in front of 12362. And then look for next cell on sheet 2 (18991) and so on.

Can you please help me do this.. Thank you in advance

I am attaching the sample file

Can anyone please help?? Please?

Wow that was quick. Mike you are the Man!! Thanks a lot for the help. The code works perfectly fine. Thanks again