IF Statement with multiple return

%3CLINGO-SUB%20id%3D%22lingo-sub-2392923%22%20slang%3D%22en-US%22%3EIF%20Statement%20with%20multiple%20return%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2392923%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20working%20with%20a%20data%20sheet%20that%20needs%20to%20have%20items%20matched%20and%20paste%20data%20from%20one%20sheet%20to%20another.%20In%20order%20to%20do%20so%20for%20thousands%20of%20inputs%2C%20I'm%20trying%20to%20use%20the%20IF%20Statement.%3C%2FP%3E%3CP%3EIf%20the%20data%20from%20any%20two%20rows%20match%20identically%20from%20their%20columns%20B-D%2C%20then%20make%20columns%20from%20E-G%20equal%20the%20same%20values%20for%20both%20rows.%20If%20false%2C%20leave%20the%20cell%20alone.%20However%2C%20whenever%20I%20input%20the%20formula%26nbsp%3B%3CEM%3E%3DIF(B2%3AD2%3DB3%3AD3%2CE2%3AG2%3DE3%3AG3%2C%22%22)%2C%26nbsp%3B%3C%2FEM%3Eit%20does%20nothing.%20Can%20someone%20help%20me%20figure%20out%20a%20formula%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2392923%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2393885%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Statement%20with%20multiple%20return%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2393885%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EDo%20rows%20E%3AG%20have%20unique%20values%20for%20each%20combination%20of%20B%3AD%3F%3C%2FLINGO-BODY%3E
New Contributor

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
Hi,
Do rows E:G have unique values for each combination of B:D?