Comparing 2 excels and update result in 2nd excel. if the row element matches (without for each loop)

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…

image this is my first excel…

image i want to get the result like this.

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