Hi all, I am trying to write an excel formula using write cell activity in UiPath (within Excel Scope Activity). However I am getting this error BC30198: ‘)’ expected I tested my formula in Excel and it works. My formula :=IFERROR(VLOOKUP(A2,‘[Source1Excel. sheet.xlsx]Sheet1’!$A:$B,2,FALSE),“NOT …

[image] lrtetala: “=IFERROR(VLOOKUP(A2,‘[Source1Excel. sheet.xlsx]Sheet1’!$A:$B,2,FALSE),”“NOT FOUND”“)” Great! That’s work, thank you!

Getting this error BC30198: ‘)’ expected on write cell with vlookup

Parvathy (PS Parvathy) July 16, 2023, 10:52am 10

@xiaozhuang-susan.wei
Please mark as solution to close the loop.

Happy Automation.
Regards,

Topic		Replies	Views
Error during Write Cell Activity (Excel Formula) Studio studio , question , activities_panel	6	717	July 17, 2023
Writing Excel Formula with UiPath to Excel not working Help excel , activities , error	4	2083	February 15, 2020
Write Cell Help studio	15	1658	February 8, 2019
Range not found error with VLOOKUP Help excel , studiox , question	4	1140	January 20, 2020
Formula Error as end of expression expected Help	7	2601	April 27, 2020