May 27 2021 10:01 AM
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?
May 27 2021 02:51 PM