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.
Refer this post,
(Join Two Data table)