Compare rows from one excel to other excel

Help
1

Hi,

I have 2 excels .

First excel have 2 columns with Name and City.
Second Excel have 2 columns Name and Age.

Now i want to pick Name from first excel and have to search in excel 2,if name matches i want to read the corresponding Age from excel 2 and store it in another excel.

kindly help on it.

Thanks

2

Hi @avinashy,
Refer this post,

(Join Two Data table)

Regards,
Arivu