Transfer of Info Sheet to Sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-861727%22%20slang%3D%22en-US%22%3ETransfer%20of%20Info%20Sheet%20to%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861727%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20sheets%2C%20each%20with%20a%20column%20of%20phrases.%20Sheet%20A%20has%20some%20phrases%20that%20are%20in%20sheet%20B.%20I%20need%20to%20add%20all%20of%20the%20phrases%20from%20B%20to%20A%2C%20that%20are%20not%20already%20in%20A.%20There%20will%20be%20a%20new%20column%20in%20A%2C%20with%20the%20data%20pulled%20from%20B.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETried%20doing%20the%20copy-paste%20method%20and%20removing%20duplicates%2C%20but%20it%20doesn't%20work%20due%20to%20the%20location%20where%20the%20added%20phrases%20will%20be%20going.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20some%20way%20to%20utilize%20VLOOKUP%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-861727%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-862441%22%20slang%3D%22en-US%22%3ERe%3A%20Transfer%20of%20Info%20Sheet%20to%20Sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862441%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411317%22%20target%3D%22_blank%22%3E%40hitchcts%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20certain%20ways%20in%20excel%20through%20which%20you%20can%20pull%20data%20from%20other%20sheets.%20%3CSTRONG%3EIndex()%3C%2FSTRONG%3E%20%26amp%3B%20%3CSTRONG%3EMatch%3C%2FSTRONG%3E()%20functions%20are%20much%20convenient%20for%20such%20requirements.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20sample%20file%20for%20your%20reference%2C%20you%20may%20also%20share%20your%20data%20in%20case%20you%20want%20to%20incorporate%20these%20formulas%20into%20your%20actual%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have two sheets, each with a column of phrases. Sheet A has some phrases that are in sheet B. I need to add all of the phrases from B to A, that are not already in A. There will be a new column in A, with the data pulled from B. 

 

Tried doing the copy-paste method and removing duplicates, but it doesn't work due to the location where the added phrases will be going. 

 

Is there some way to utilize VLOOKUP? 

1 Reply
Highlighted

Hi @hitchcts 

 

There are certain ways in excel through which you can pull data from other sheets. Index() & Match() functions are much convenient for such requirements.

 

I have attached a sample file for your reference, you may also share your data in case you want to incorporate these formulas into your actual file.

 

Thanks

Tauqeer