Imagine I have the following Excel file 1:
Imagine that I have the following Excel file 2:
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:
I tried to use the new “lookup” activity, but I wasn’t able to do anything with it.
Does anyone have any idea how to do this in an easy manner?