Forum Discussion
ControlV
May 27, 2021Copper Contributor
IF Statement with multiple return
Hello, I am working with a data sheet that needs to have items matched and paste data from one sheet to another. In order to do so for thousands of inputs, I'm trying to use the IF Statement.
If the data from any two rows match identically from their columns B-D, then make columns from E-G equal the same values for both rows. If false, leave the cell alone. However, whenever I input the formula =IF(B2:D2=B3:D3,E2:G2=E3:G3,""), it does nothing. Can someone help me figure out a formula?
1 Reply
- StoneKiwiIron ContributorHi,
Do rows E:G have unique values for each combination of B:D?