Vlookup between two different excel file sheets

[suresh_kumar4 (suresh kumar)]

hi @Palaniyappan,

Hope you can help me out this…

Comparing 2 excels and update result in 2nd excel. if the row element matches

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 1st excel… [image] this is my 2nd excel… so the result to be updated like this …status column can any one help m…

Thanks,
Suresh.