Home

Trying to merge data between sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-862233%22%20slang%3D%22en-US%22%3ETrying%20to%20merge%20data%20between%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862233%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Excel%20community%2C%20im%20trying%20to%20%22marry%22%20data%20in%20one%20sheet%20to%20populate%20data%20in%20a%20column%20in%20another%20sheet.%20I'm%20not%20a%20pro%20at%20this%20and%20i%20have%20not%20come%20up%20with%20any%20solutions%20or%20found%20any%20searching%20for%20it.%20For%20example%20one%20sheet%20has%20column%20A%20first%20name%2C%20column%20B%20last%20name%2C%20column%20C%20age.%20i%20want%20to%20%22marry%22%20the%20name%20with%20the%20age%20to%20bring%20it%20into%20sheet%202%20that%20has%20Column%20A%20last%20name%2C%20Column%20B%20first%20name%2C%20Column%20C%20State%20and%20column%20D%20is%20where%20i%20want%20the%20age%20inserted%20from%20sheet%20one.%20The%20same%20names%20are%20in%20both%20sheets%20however%20the%20names%20are%20repeating%20and%20the%20states%20are%20too%2C%20as%20long%20as%20the%20age%20is%20tied%20to%20first%20and%20last%20name%20it%20will%20show%20the%20age%20number.%20How%20can%20i%20do%20this%20and%20is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-862233%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-862275%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20merge%20data%20between%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-862275%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20note%20this%20is%20for%20my%20job%20assigning%20door%20access%20to%20people%20in%20a%20building%20and%20not%20a%20sheet%20about%20peoples%20ages%20and%20names%2C%20much%20more%20important%20but%20my%20example%20is%20as%20close%20as%20i%20think%20i%20need%20to%20be%20to%20find%20a%20solution%2C%20thanks.....%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411461%22%20target%3D%22_blank%22%3E%40Jaarrrr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-870023%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20merge%20data%20between%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870023%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20has%20been%20solved%20by%20an%20Excel%20guy%20in%20my%20office%2C%20thanks%20for%20your%20views%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411461%22%20target%3D%22_blank%22%3E%40Jaarrrr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Jaarrrr
New Contributor

Hello Excel community, im trying to "marry" data in one sheet to populate data in a column in another sheet. I'm not a pro at this and i have not come up with any solutions or found any searching for it. For example one sheet has column A first name, column B last name, column C age. i want to "marry" the name with the age to bring it into sheet 2 that has Column A last name, Column B first name, Column C State and column D is where i want the age inserted from sheet one. The same names are in both sheets however the names are repeating and the states are too, as long as the age is tied to first and last name it will show the age number. How can i do this and is this possible?

2 Replies

To note this is for my job assigning door access to people in a building and not a sheet about peoples ages and names, much more important but my example is as close as i think i need to be to find a solution, thanks.....    @Jaarrrr 

This has been solved by an Excel guy in my office, thanks for your views@Jaarrrr 

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