Merge info from two tables

Copper Contributor

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.