Comparison/Matching

[OzarkScan]

I have two spreadsheets with similar information.  I need to merge the two together with the columns being used to match the row. 

Ex:  Spreadsheet 1 has Jane Doe on Row 25 in Column A,  Spreadsheet 2 has Jane Doe on Row 65 in Column A.  

Is there a way to merge and then sort them so that data pertaining to Jane Doe ends up in the same row? 

[#2]

@OzarkScan 

Many questions arise from your inquiry.

For example, it is not clear what should happen with the double values in different lines.

What if line 65 says something else on sheet one and something else on sheet two?

... or in line 25, what else is on the other sheet?

With your permission, please read the information in the attached link.

This information will make life easier for you as well as for the helpers.

Above all, you will receive proposals for solutions that are much faster and tailored to your needs.

Welcome to your Excel discussion space!

Thank you for your time and understanding

Nikolino

I know I don't know anything (Socrates)

[#3]

@OzarkScan 

You may try fuzzy match with Power Query

Create a fuzzy match (Power Query) - Excel (microsoft.com)

How fuzzy matching works in Power Query? | Microsoft Docs