How to compare this two excel files using “Ref. No.” column in vendor excel and “Invoice” column in ledger excel and make match mismatch report in two separate excels containing ref no and am Vendor.xlsx (8.8 KB) ount from vendor and invoice no and amount from ledger. Ledger_ax.xlsx (10.6 KB)

Compare two Datatable using contains

Nithinkrishna (Nithin Krishna) February 24, 2022, 2:24pm 3

Please find the below ref,

Hope this helps

Thanks
#nK

Topic		Replies	Views
I want to compare two datatables Activities excel , activities , question	3	104	June 20, 2024
How to keep same valued cells between 2 excel documents Help datatable , excel , activities , question	16	801	October 21, 2020
Compare two DT with one column and get unmatched records Studio datatable , excel , question	16	6252	September 28, 2020
Compare two different data tables through linq Studio uiautomation	9	2792	January 19, 2022
Matched and Unmatched data in excel Help datatable , excel , activities , question	10	3101	March 5, 2020