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	954	December 1, 2022
Compare two different excel sheets and write matching result in both the sheets Studio studio , question , activities_panel	7	1063	April 15, 2021
Compare Excel/Lookup Data Table without getting same value Activities excel , activities , question	6	997	September 27, 2020
Compare two datatables Help	8	4002	July 16, 2020
Compare Excel sheets and write data in new sheet Studio datatable , excel , activities , question	17	2042	March 23, 2020