I hope someone can help me here.

I have a workbook with two worksheets (I will call them worksheet1 and worksheet2), from worksheet1 I need to test the values of two dfferent columns with the values of two different columns in worksheet2. When both batches are true - I want to copy the value of another column, same row as the match from worksheet1 to worksheet2.

Below is my logic, I just don't know how to write in excel:
If value in column 1 of worksheet1 = value in column 1 of worksheet2 and value of column 2 of worksheet1 = value in column 2 of worksheet2, then copy the content of column 3 (same row) from worksheet1 to worksheet2.

Thanks so much!!
Winston