Using C# Read data in two sheets first columns if matched sheet2 clumn2 data should paste in sheet1 column2

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

Hi @Sairam_Narayanam

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