Hi peter,
i have two excel file (dt1 & dt2).
After filtering the dt1 I have a set of rows.
Of these rows, only for those that have certain codes in the “Code” column (example: code = ‘300’, ‘301’, ‘302’), I need to compare them with the second excel file (dt2), and extract all rows that have 4 columns in common (example: dt1 invoice_number = dt2 n_invoice AND dt1 date = dt2 date_invoice AND so on. ). – DT1 and DT2 has different column name.
At this point I need to find all the rows in dt2 that have those conditions in common. So basically I could have 2 rows in dt1 and more rows in dt2.
if you need a more explanatory excel file let me know.
Thanks in advance