faceplant247
New member
- Joined
- Feb 28, 2013
- Messages
- 1
- Reaction score
- 0
- Points
- 0
I’m trying to combine information from two spreadsheets into one by matching the last name and first name from each.
So, for instance, in sheet 1, I have last name and first name in separate cells followed by info in cells after. In a separate sheet I have (in about half of the cases) the same Last Name and First Name followed by different info in cells after.
I want to combine the two sheets into one sheet by matching the Last Name and First Name followed by all of the pertinent info from both sheets.
If the Last and First Name is not present in both sheets I still want it to populate in the new sheet with Last and First name followed by the info from the 1 sheet.
Any help is appreciated.
So, for instance, in sheet 1, I have last name and first name in separate cells followed by info in cells after. In a separate sheet I have (in about half of the cases) the same Last Name and First Name followed by different info in cells after.
I want to combine the two sheets into one sheet by matching the Last Name and First Name followed by all of the pertinent info from both sheets.
If the Last and First Name is not present in both sheets I still want it to populate in the new sheet with Last and First name followed by the info from the 1 sheet.
Any help is appreciated.