How to use vlookup in excel without using macros

[ppr (Peter Preuss)]

in general we do use the join concept:

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…

we would recommend following:

• clear the details like join type: expected output …
• do a start with the join datatable activity and postprocess the join result to get the needed output

in case of this will not serve your needs then we can check for a LINQ