Thanks in advance.
Using 2 for each for Dt1 and Dt2 as row1 and row2,
When match found in row1 data with row2
then in assign use row2 varible to fetch all data from 2nd Excel.
like row2(column_index).toString or row2(“Column_Name”).toString
you can use this condition inside for each loop
here -1 represents that G410717224 is not present in that row. So we did a not to make sure we extract value only when the G410717224 is there in the row.
in then part you can use this to index of that value!
row.Item(row.ItemArray.ToList.IndexOf(“G410717224”) + 1).ToString