Skip to main content
Question

compare two excel files and update the mismatch data in another workbook

  • October 23, 2025
  • 2 replies
  • 40 views
R
Forum|alt.badge.img+1

Compare Two Excel Files

File 1: Invoice_Jan.xlsx
File 2: Invoice_Feb.xlsx

Both contain:

Invoice_No Vendor Amount
INV001 ABC Corp 1000
INV002 XYZ Pvt 2000
INV003 LMN Ltd 1500

 

Invoice_No Vendor Amount
INV001 ABC Corp 1000
INV002 XYZ Pvt 2100
INV003 LMN Ltd 1500

👉 Compare Invoice_No and Amount —
if mismatch or missing, log invoice_no vendor amount details to Mismatched_Invoices.xlsx

2 replies

Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • Padmakumar
  • Premier Pathfinder | Tier 7
  • 1171 replies
  • October 24, 2025

Hi ​@rishav_anand,

 

Could you please be more specific on what exactly your issue is? Or do you need a step-by-step approach to automate this process?

Padmakumar
Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+17
  • Zaid Chougle
  • Navigator | Tier 3
  • 225 replies
  • October 31, 2025

Compare Two Excel Files

File 1: Invoice_Jan.xlsx
File 2: Invoice_Feb.xlsx

Both contain:

Invoice_No Vendor Amount
INV001 ABC Corp 1000
INV002 XYZ Pvt 2000
INV003 LMN Ltd 1500

 

Invoice_No Vendor Amount
INV001 ABC Corp 1000
INV002 XYZ Pvt 2100
INV003 LMN Ltd 1500

👉 Compare Invoice_No and Amount —
if mismatch or missing, log invoice_no vendor amount details to Mismatched_Invoices.xlsx

Hi ​@rishav_anand ,

 

You can either use different session to open both the excels and use a nested loop to check both the rows, else you can use excel as a Db and then use a join to satisfy your scenario.

 

That being said, ​@Padmakumar is right, can you please elaborate what it is that you are looking out for?

Lets Automate !


Terms & ConditionsCookie settingsAccessibility statement