Hi All, I have 2 excel files, one excel files with one sheet and the other file with three sheets. Description Excel file1 has1 sheet with 30+ columns out of which only email id have to be compared with all the three sheets of the Excel file 2 and write back the matched mail id information with E…

@selvarani1390 Check below file once. output is written in output.xlsx Sample Files.zip (36.6 KB)

How to compare two excel files for one column

HareeshMR (Hareesh Madasi) January 4, 2019, 6:20am 4

Please find the attached workflow to compare sheet1 from both Excel1 and Excel2.

Same way you can loop for sheet2 and 3 also.

Hope it helps and let me know if you still have doubts.

Thanks,
MR

How to compare the values of specific column in 2 different excel sheet?

Comparison between two excel sheets

Topic		Replies	Views
Compare excel sheet with different columns from different files Help	37	1918	March 16, 2019
Need to compare two excel files with the same column and fill the values Studio studio , question , activities_panel	3	152	April 10, 2024
Comparing two columns in Excel not rowwise Help datatable , excel , activities , studio	17	2578	September 22, 2019
How to Match columns of two different excel files and send an email Help	9	1317	October 3, 2019
Compare two Excel coulmns and return how many items matched Help	3	918	July 4, 2019