I have two sheets that I will compare between them then create a new sheet for the result requirements : If values in sheet1 exist in sheet2, and values in sheet2 exist in sheet1, create a new column in the result sheet call it Result then assign it to “Match” otherwise, return the new values in …

Compare between 2 sheets

RajKumar_DC (RajKumar Durai) December 1, 2022, 8:56am 2

What about below workflow. Check Xaml with attached Excel File

Xaml
kalmajhad.xaml (11.0 KB)

Ecxel
Master.xlsx (10.2 KB)

Output

Best,
Rajkumar

How to compare columns between two different sheets

Topic		Replies	Views
How to compare columns between two different sheets StudioX studiox , question	3	963	December 1, 2022
Compare two different excel sheets and write matching result in both the sheets Studio studio , question , activities_panel	7	1149	April 15, 2021
Compare two datatables Help	8	4040	July 16, 2020
Compare Excel sheets and write data in new sheet Studio datatable , excel , activities , question	17	2051	March 23, 2020
Comparing Excel Sheets with Different Row Count Help excel , activities , question	14	1562	January 13, 2020