Hi All,

How to drag the formula to all the rows in a particular column? I am performing Vloop up based on other sheet and the range keeps changing constantly

Hi All,

How to drag the formula to all the rows in a particular column? I am performing Vloop up based on other sheet and the range keeps changing constantly

1 Like

Fine

â€“initially get the datatable from excel with read range activity and get the output with a variable of type datatable named dt, within excel application scope

â€“now use FOR EACH ROW loop and pass the variable dt as input

â€“insde the scope use WRITE CELL activity and mention the formula we have as input string between double quotesâ€¦and in the range mention as if its C column we are going to use the formula then the range be like

**"C"+(dt.Rows.IndexOf(row)+2).ToString**

â€“so that it will use this formula till the row end everytime even though we dont the row count

hope this would help you

Cheers @Pkotla

Thank you for your response. But I see the same ID getting replaced in all the rows. Here is the formula I am using in the first row along with the screenshot.

formula : =VLOOKUP(D2,â€™[exceldocument.xlsx]sheet1â€™!$1:$1048576,3,FALSE)

@Palaniyappan , please let me know if I am doing something wrong.