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
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
Hello,
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)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.