How to look up a value in same excel sheet

[samir (Samir Mohite)]

Hi @cheersrpa,

This is quite similar to your case, just go through this thread,

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 …