How to copy data from sheet1 to sheet2 with a condition in Excel

Question

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.

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

Answer 1

Try do debug it step by step. What happens, if you change your formula in:

=IF((Sheet1!B2:B3=Sheet2!A2:A3),Sheet2!D2)

?

Or

=IF((Sheet1!B2:B3=Sheet2!A2:A3),"the same values")

Maybe not all the values are really exactly the same in columns A and B. Or D2 doesn't contain what you expect.

Answer 2

this should do what you are after.

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

Answer 3

Put the following formula in the first cell of column G

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

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

Answer 4

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

Answer 5

I want to kanw about copy sheet1 data to sheet 3 if sheet1 data a5 is empty then sheet2 a2 data placed (copy) into sheet3(a5)Col.

Answer 6

i want to know, how to add 2 values. That is, one value at sheet 1 and second value at sheet 2 in excel. Not use formula. Use + sign.

eg:------------------------ ------------------------- | 100 | | | | | ------------------------ ------------------------- | | | | | 200 | ------------------------ ------------------------- Sheet 1 sheet 2