Order two columns based off two other columns order

Hi,

Would someone be able to help me out with a problem I have.

Basically I have two lists, one is the unordered (raw) data with various other information and the other is the ordered list without the various information.

Is it possible to order the raw data columns based off the ordered list columns?

I have attached the excel file, where I have highlighted the raw data with various information to the left and right of "first names" and "last names".

I have also the ordered "first name" and "last names".

What I want to learn is how to order the raw data such that I get the desired result.

I have tried to make another column right next to the last name on the daw that and used the =MATCH function, but the issue is when I have identical first name, it fails.

I use excel 365.

Thank you

I guess this is just generic data but I would possibly approach like this:

Please Login or Register  to view this content.

Replace J$3:J$7 and K$3:K$7 with the ranges of the first and second names. You can then copy those formulas down the column. Then to get the data for each name:

Please Login or Register  to view this content.

Again, you'd need to adjust the ranges as appropriate. This formula can then be copied down and into the other columns. See attached.

WBD

Administrative Note:

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect: there are 2019, 2021 and 365 versions, so I'm not sure yours is correct here. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

The logic is sound. The only issue is if you have two identical names (e.g. two people called John Smith). Did you open the attachment I sent which has two people called John but the information is correctly retrieved?

WBD

I see you've updated your MS Office version to 365. In that case, you could also use XLOOKUP in A11:

Please Login or Register  to view this content.

That would also work copied across and down.

WBD

I'm not sure what you've attached there but perhaps you were only using the first name in the MATCH() formula. My solution concatenates the first and second names to do a lookup on multiple columns.

WBD