Merge info from two tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2774236%22%20slang%3D%22en-US%22%3EMerge%20info%20from%20two%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2774236%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%3C%2FP%3E%3CP%3EI%20have%20two%20tables%20with%20several%20columns.%26nbsp%3B%3C%2FP%3E%3CP%3ESay%3C%2FP%3E%3CP%3E%3CSTRONG%3ENames...Age..Phone%20no%3C%2FSTRONG%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20and%20%3CSTRONG%3ENames...Address...Email%20ID%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20names%20are%20the%20same%20but%20not%20in%20the%20same%20order..How%20can%20i%20now%20merge%20the%20information%20of%20the%20other%20columns%20so%20that%20i%20have%20one%20table%20with%20the%20following%20columns%3C%2FP%3E%3CP%3E%3CSTRONG%3ENames...Age..Phone%20no..Address..Email%20ID..%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%20I%20dont%20have%20programming%20knowledge%2C%20therefore%20looking%20for%20something%20that%20can%20be%20done%20in%20Excel.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2774236%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi everyone

I have two tables with several columns. 

Say

Names...Age..Phone no      and Names...Address...Email ID

 

The names are the same but not in the same order..How can i now merge the information of the other columns so that i have one table with the following columns

Names...Age..Phone no..Address..Email ID..

 

Thanks for your help. I dont have programming knowledge, therefore looking for something that can be done in Excel.

Thanks

1 Reply

@souvik19831360 Look into the use VLOOKUP or XLOOKUP if your Excel version supports it.