问题描述
在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的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!