Excel activity - vlookup excel using writecell activities till cell values

I am getting error while performing vlookup function in excel using uipath.

Basically i wanted to do lookup until last cell (value available) as getting error. its certain cell after not working lookup, pls take a look



Either use WriteRange or target a cell (H2:H16 is a range).

Range not to define till entire column

Example : A Column having data, i wanted to lookup the data till row having values.
Thats why i used tostring.
“H2:H” +count.tostring

You’re iterating on each row. At each pass, you write into the cell H & counter the formula resulting from
String.Format("=VLOOKUP(C{0}, Sheet1!A:B, 2, 0)", counter.ToString)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.