Excel matching two files and write cell for match values

[samir (Samir Mohite)]

hi @Htwe_Ko_Ko_Wynn,

You can simply use LookUp Datatable activity inside for each row activity.
using lookup datatable activity you can search for a value in datatable and returns value from another column.

Check out this example…

Facing issue while extracting data from data table

Hi @AryanSingh You can use Lookup DataTable activity here, you have max bill month stored in “LastMonth” variable. So parameters of lookup datatable should be, Input :- Datatable —> datatable variable Lookup Value —> LastMonth variable Lookup Column :- ColumnName —> “Bill Month” Output :- CellValue —> create system.double variable here(to store Actual balance amt) Target Column :- ColumnName —> “Actual Balance Amt” So that’s how you’ll get actual balance amt value in cellValue …