如何使用Excel中的条件将数据从sheet1复制到sheet2

In excel workbook I am trying to copy data from sheet1 to sheet2 with a condition, IF((Sheet1!B2:B80=Sheet2!A2:A80),Sheet2!D2) i am not getting the result.please help me solve this.In excel workbook I am trying to copy data from