Use vlookup on filtered data

[Lak_Ui (Lakshmi)]

Vlookup column from one excel file into another using linq query

Hey guys, Can someone create process for Vlookup two files attached using linq query and send me .xaml file?Files excel.7z (171.1 KB) I created process using LookupDataTable, but it takes 2.5 hours to perform lookup. Screen of the files in the picture below: [File1_File2] In the result I need: [Vlookup_result]

Check this thread