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


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?

Thank you!

Hi jcab, to achieve this you can simply load both sheets into a DataTable and use the select statement on the DataTable to find it. I attach a small workflow to demonstrate this. This workflow assumes the Found column has already been added in Excel1.ExcelLookup.xaml (8.2 KB)


is this what you want ?

matchrecords.xaml (9.5 KB)
Get Non-matched Items.xaml (9.7 KB)

1 Like

@antonroux, that looks great, thanks!

Thanks :slight_smile:

Could you also please attach the workflow “Component for Two Datatable Column Match and Get The Matched Records.xaml” you are invoking ? :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.