Hi Guys,

I have excel1 with **Test case column same in excel2**… but the test case places where different…

here i want to update the result in 2nd excel…to the respective test case… If the test case matches…

**In my first excel test_01 is in 1st row…and in my 2nd excel “test_01” is for example 10th row…so i want to update the result in 10th row in status column…**

this is my 1st excel…

this is my 2nd excel…so the result to be updated like this …**status column**

can any one help me out without using **for each loop here**… i got the answer using for each …here the problem is if **i have some 1000 rows its taking some time to produce the result**…so i want to know how

can i get the same result without using for each loop…

**“D”+(sheet2DT.Rows.IndexOf(row_sheet2)+2).ToString** i have used this expression to get the result using for each…

Thanks,

Suresh