Excel formula escape character

[PrajjwalRai]

Hi,

I was trying to use the following excel formula in Blue Prism 

"=IF(ISERROR(VLOOKUP(I4,RCA!$C$1:$D$13,1,0)),"DC2","DC1")"

I am getting misplaced " error.

Can someone please guide me in resolving this?

Regards,
Prajjwal

------------------------------
Prajjwal Rai
Application Engineer
Schneider Electric Private Limited
------------------------------

[GopalBhaire]

Where are you getting this error? I would suggest you store the Formula in dataitem and pass it to the action.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

[PrajjwalRai]

The expression is not valid, since you see there are quotes in between the text, in DC2 and DC1. I need to use escape character for this, can you guide?

------------------------------
Prajjwal Rai
Application Engineer
Schneider Electric Private Limited
------------------------------

[GopalBhaire]

Set it as ""DC1"",""DC2""

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------