Compare 2 excel file columns

[Tiberiu_Niculescu (Tibi)]

Lookup a record of Excel file 1 in Excel file 2 and set column if found

Hi! Imagine I have the following Excel file 1: [Excel%20file%201] Imagine that I have the following Excel file 2: [Excel%20file%202] I want to make a simple vlookup and check which of the the NB values (1st Excel column) of all the records of Excel file 1 are in Excel file 2. And create a column in Excel file 1 with a “1”, of the records of Excel 1 which have been found in Excel file 2. The result would be this: [Excel%20file%201] I tried to use the new “lookup” activity, but I wasn’t abl…

next time, try using the search function.