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

Help Studio
1

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 FOUND”)

2

Hi @xiaozhuang-susan.wei

Give that formula in double quotes.

“=IFERROR(VLOOKUP(A2,‘[Source1Excel. sheet.xlsx]Sheet1’!$A:$B,2,FALSE),“NOT FOUND”)”

Regards,

3

yep, I’ve done that still same.

4

Hi @xiaozhuang-susan.wei

Welcome to Community!

Try this

formula = “=IFERROR(VLOOKUP(A2,‘[Source1Excel. sheet.xlsx]Sheet1’!$A:$B,2,FALSE),”“NOT FOUND”“)”

5

@xiaozhuang-susan.wei

Try this:

“=IFERROR(VLOOKUP(A2,‘[Source1Excel. sheet.xlsx]Sheet1’!$A:$B,2,FALSE),”“Not FOUND”“)”

Regards,

6

@xiaozhuang-susan.wei

Are you tried this? It is working. Please try this.

7

Hi @xiaozhuang-susan.wei

When you are giving the value or formula in write cell activity fields you have to give in between double quotes. You just forget to give the formula with in double quotes.
Give a try to give the formula with in double quotes in the write cell activity.

"=IFERROR(VLOOKUP(A2,‘[Source1Excel. sheet.xlsx]Sheet1’!$A:$B,2,FALSE),“NOT FOUND”)"

Copy and paste the above one in the Write cell activity.

Hope it helps!!

8

Great! That’s work, thank you!

9

@xiaozhuang-susan.wei

Please mark as solution to close the thread.

Regards,

10

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

Happy Automation.
Regards,

11

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