Excel Lookup Range for Cell with Formula

Hi,
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

Hi
Is the Range mentioned in such a like the value or cell lies within that
Or
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
—Inside that loop use LOOKUP DATATABLE ACTIVITY
—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?