Compare and match 2 Columns

Hello @aworker @ipazin @HansS ,

thank you very much for your answers!

@aworker you described my problem very well. Permutations is a complicated part of the issue. I have prepared 2 Excels with about 20 rows. The original document have more than 8k rows.

Extra information:

The column “Product” of the “Insurance” document at best contains the information found in the columns “Functional location” and “Technical Object” of the “Maintenance” document.

Thank you very much for your help!

Insurance.xlsx (11.6 KB)
Maintenance.xlsx (10.6 KB)

3 Likes