如何使用Excel中的条件将数据从sheet1复制到sheet2 [英] How to copy data from sheet1 to sheet2 with a condition in Excel

问题描述

在excel工作簿中，我试图将数据从sheet1复制到sheet2，条件是IF（（Sheet1！B2：B80 = Sheet2！A2：A80），Sheet2！D2）我没有得到result.please帮助我解决这个问题。

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.

如果表1中列B的值等于sheet2列A中的值，我试图从sheet1复制到sheet2应将表2中的列D中的值复制到sheet1的列G

I am trying to copy from sheet1 to sheet2 with a condition if the the value in sheet 1,column B is equal to the value in sheet2 column A the value in column D of sheet 2 should be copied to column G of sheet1

推荐答案

将以下公式放在列的第一个单元格中G

Put the following formula in the first cell of column G

=IF((Sheet1!B1=Sheet2!A1), Sheet2!D1)

然后根据需要复制这个单元格。 Excel将更改所有单元格引用。

then copy this cell down as far as you need to. Excel will change all the cell references for you.

这篇关于如何使用Excel中的条件将数据从sheet1复制到sheet2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！