Home

Formulas Excel assistance

%3CLINGO-SUB%20id%3D%22lingo-sub-1283248%22%20slang%3D%22en-US%22%3EFormulas%20Excel%20assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1283248%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EThat%20on%20a%20sheet%20column%20b%20if%20it%20matches%20the%20data%20on%20a%20different%20sheet%20column%20b%2C%20then%20it%20needs%20to%20copy%20then%20if%20not%2C%20do%20not%20copy.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1283248%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1283258%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20Excel%20assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1283258%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20didn't%20attach%20any%20file%20to%20understand%20the%20question%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1283268%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20Excel%20assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1283268%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3BI%20am%20trying%20match%20from%20this%20sheet%201%20on%20column%20B%20where%20same%20order%20ID%20on%20another%20sheet%202%20on%20column%20B.%26nbsp%3B%20I%20not%20have%20to%20look%20up%20the%20order%20id%20then%20copy%20from%20column%20D%20to%20i%20to%20fill%20out%20on%20Sheet%201%20to%26nbsp%3Bcolumn%20K%20to%20P%20if%20Order%20ID%20matched.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1283296%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20Excel%20assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1283296%22%20slang%3D%22en-US%22%3Ehow%20to%20attach%20the%20file%20that%20i%20want%20show%20you%20my%20example%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1283306%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20Excel%20assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1283306%22%20slang%3D%22en-US%22%3EI%20just%20upload%20the%20files%20for%20example..%20let%20me%20know.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1301254%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20Excel%20assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1301254%22%20slang%3D%22en-US%22%3EI%20been%20wait%20please%20help%20me!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1301496%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20Excel%20assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1301496%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F610300%22%20target%3D%22_blank%22%3E%40DEAF_DWJr98%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHard%20without%20seeing%20the%20workbook%20but%20you%20could%20try%20using%20this%2C%20in%20cell%20C1%20of%20Sheet2%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(B1%3DSheet1!B1%2C%20Sheet1!B1%2C%20%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1301863%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20Excel%20assistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1301863%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F610300%22%20target%3D%22_blank%22%3E%40DEAF_DWJr98%3C%2FA%3E%26nbsp%3BPerhaps%20like%20in%20the%20attached%20file%3F%20None%20of%20the%20orders%20on%20the%20first%20sheet%20matched%20the%20ones%20in%20the%20second%2C%20so%20I%20copied%20some%20data%20there%20to%20test%20a%20solution%20with%20VLOOKUP.%26nbsp%3BIf%20you%20are%20on%20the%20latest%20version%20of%20Excel%20you%20might%20want%20to%20have%20a%20go%20at%20it%20yourself%20with%20XLOOKUP.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

That on a sheet column b if it matches the data on a different sheet column b, then it needs to copy then if not, do not copy.

7 Replies
Highlighted
Hello,

You didn't attach any file to understand the question
Highlighted

@Abiola1 I am trying match from this sheet 1 on column B where same order ID on another sheet 2 on column B.  I not have to look up the order id then copy from column D to i to fill out on Sheet 1 to column K to P if Order ID matched. 

Highlighted
how to attach the file that i want show you my example
Highlighted
I just upload the files for example.. let me know.
Highlighted
I been wait please help me!
Highlighted

@DEAF_DWJr98 

 

Hard without seeing the workbook but you could try using this, in cell C1 of Sheet2:

 

=IF(B1=Sheet1!B1, Sheet1!B1, "")

Highlighted

@DEAF_DWJr98 Perhaps like in the attached file? None of the orders on the first sheet matched the ones in the second, so I copied some data there to test a solution with VLOOKUP. If you are on the latest version of Excel you might want to have a go at it yourself with XLOOKUP.