2 Excel Workbooks - Find Match in Column 1 and Compare Column 2 for each

Help
, ,
1

I have 2 Excel Workbooks that I want to compare.

Workbook 1: Item Column & Price Column
Workbook 2: SKU Column & Cost Column
Workbook 3: Created by UiPath

  1. Find each specific Item # (Workbook 1) in the SKU Column (Workbook 2) **Not located in the same row of the other workbook
  2. If Workbook 2 doesn’t have the Item # or Workbook 1 doesn’t have the SKU # then add Item #/SKU # to sheet 1 in Workbook 3
  3. Determine if the Price & Cost Columns match for matching Item # & SKU # (Add to Workbook 3 Sheet 2)
  4. Price & Cost Columns don’t match for matching Item # & SKU # (Add to Workbook 3 Sheet 3)
  5. Price & Cost Columns aren’t in the system (N/A) for matching Item # & SKU # (Add to Workbook 3 Sheet 4)

Reading the Excel files is no problem. I am struggling with the comparisons/look-ups. Any help would be much appreciated. The actual data that I am looking at will have 1 million lines.

Workbook 1.xlsx (10.6 KB) Workbook 2.xlsx (10.6 KB)

2

Hi @OviattTG

use multiple for each loop for both workbook1 and workbook2

row(“Item”).ToString.Equals(row(item).ToString

use add data row activity

based on Equals try to do manipulations like other columns

Thanks
ashwin S