Hi all, I have a quick question in relation to 'alignment'.

I have a list of 2.5k records of our clients which contains;

Rank, First Name, Last Name, Address 1, Address 2, Town/City, County, Postcode.

I then have another list, with the same details but with an 'email' column instead of the 'rank' column. Both spreadsheets are in completely different order.

I would like to align this 'email' column from this second spreadsheet to my original spreadsheet with the 'rank' in it so I have both. I will need to align this using the 'First Name' AND 'Last Name' fields, as there will be multiple Joe's in the list and hence need alignment based on both - first name and last name. From what I understand what I need to do is create an empty column with a formula to join up first name and last name so that I can find duplicates using both fields in one;

Joe | Smith | JoeSmith

After doing this in both spreadsheets, I would like to tell excel to find 'JoeSmith' from spreadsheet 2 and align it along with its email address next to 'JoeSmith' in spreadsheet 1. I'm looking to achieve the below;

Joe Smith | Rank | Email | Address 1 | address 2 | Town/City | County | postcode.

I'd like to do this across all 2.5k records.

Is there a simple way of doing this?

Any feedback will help massively!
Thank you so much in advance!