Home

Excel merge question

%3CLINGO-SUB%20id%3D%22lingo-sub-868353%22%20slang%3D%22en-US%22%3EExcel%20merge%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-868353%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20one%20file%20of%20updated%20addresses%20for%20my%20database%20which%20contains%20no%20Account%20IDs.%3C%2FP%3E%3CP%3EI%20have%20one%20master%20file%20which%20includes%20the%20Account%20ID%20of%20all%20addresses.%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%203rd%20file%20that%20enters%20the%20correct%20Account%20ID%20into%20my%20updated%20addresses%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-868353%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-868525%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20merge%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-868525%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412776%22%20target%3D%22_blank%22%3E%40JFoo98%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3Edo%20you%20have%20any%20common%20(matching)%20field%20between%20the%20file%20having%20the%20correct%20addresses%20and%20the%20other%20file%20having%20the%20Account%20ID%3F%3C%2FP%3E%3CP%3Ewhether%20you%20use%20a%20function%20(VLookup%2C%20XLookup%2C%20Index%2C%20Match...)%20or%20you%20create%20a%20data%20model%20in%20Power%20Pivot%2C%20or%20you%20create%20a%20Merge%20Query%20in%20Power%20Query%2C%20in%20all%20these%20options%2C%20there%20should%20be%20a%20matching%20field%20to%20combine%20data%20from%20the%202%20sources.%3C%2FP%3E%3CP%3Eif%20you%20do%2C%20then%20the%20ask%20is%20easy.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-870708%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20merge%20question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870708%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20all%20fields%20are%20the%20same%20in%20each%20file.%26nbsp%3B%20I%20am%20just%20missing%20the%20Account%20IDs%20in%20the%20updated%20address%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
JFoo98
New Contributor

I have one file of updated addresses for my database which contains no Account IDs.

I have one master file which includes the Account ID of all addresses.

I need to create a 3rd file that enters the correct Account ID into my updated addresses file.

2 Replies

@JFoo98 

Hi 

do you have any common (matching) field between the file having the correct addresses and the other file having the Account ID?

whether you use a function (VLookup, XLookup, Index, Match...) or you create a data model in Power Pivot, or you create a Merge Query in Power Query, in all these options, there should be a matching field to combine data from the 2 sources.

if you do, then the ask is easy.

Thanks

Nabil Mourad

@nabilmourad 

 

Yes, all fields are the same in each file.  I am just missing the Account IDs in the updated address file.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies