Forum Discussion

ControlV's avatar
ControlV
Copper Contributor
May 27, 2021

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

  • StoneKiwi's avatar
    StoneKiwi
    Iron Contributor
    Hi,
    Do rows E:G have unique values for each combination of B:D?

Resources