Using C#
Read sheet1 first column (First name)data
Read sheet 2 first column (First name)data
if two firstname data are matched
paste sheet2 colum2 (lastname) data in matched sheet1 column2 (lastname Clolumn
you only need the last of those in resultant whose first names got matched is it ?
yes i need whose first name got matched in two sheets, i need last name data in sheet2 should pate it in sheet1 lastname column in c# expreesion