Compare rows from one excel to other excel

excel

#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


How to get the row index through selecting another datatable?
#2

Hi @avinashy,
Refer this post,


(Join Two Data table)

Regards,
Arivu