Excel Lookup Range for Cell with Formula

I have a cell and the cell value is calculated by Excel formula. When I use lookup range activity to lookup the cell, it returns null. Is there any work around? Thanks.

1 Like

Is the Range mentioned in such a like the value or cell lies within that
We got one more option
—Like first read the table from excel with READ RANGE activity and get the output with a variable of datatable named dt
—Then using a FOR EACH ROW activity and pass the above obtained datatable variable as input
—Were we wil be able get the output we want
Like this in property panel
Input - row(“yourcolumnname”).ToString
Datatable - dt
Lookup column name - “column name”. // to be taken as lookup

Target column name - “column name “. // to be taken as our output

Result - stroutput which will be our string output variable

Cheers @YY.Hui

Is this cell fixed? You can choose to get the cell if it is fixed, otherwise read it into a datatable and then loop

I am facing the same issue , cant say if this is gonna work

@Palaniyappan I am facing the same issue, i did put it in the loop and then added the lookup data table, but it is not reading the column which has formulas (vlookup). I tried on other column and it worked. Is there any other work around?