compare values in different sheets

[naflas]

As attached, there are two excel work sheets sheet1 and sheet2.

I want to compare sheet 2:coulmn A and B: every row with sheet1’s column A and B.

If the sheet 2 values is existed in sheet 1 then take the adjacent values in the column C and D (in sheet1), and put them in Sheet 2’s column C and D.

Please help me out on this .

[watersev]

hi, naflas, there are many ways to do that. Here are some of them:
1. Array formula - attachment 1
2. With helper column and standard formula - attachment 2
Hope this helps

[watersev]

another solution with macro, press button on Sheet2