Trying to merge data between sheets

Copper 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