topic RE: Excel formula escape character in Product Forum

Excel formula escape character

PrajjwalRai — Tue, 24 Mar 2020 09:11:00 GMT

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
------------------------------

RE: Excel formula escape character

GopalBhaire — Tue, 24 Mar 2020 10:09:00 GMT

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
------------------------------

RE: Excel formula escape character

PrajjwalRai — Tue, 24 Mar 2020 10:30:00 GMT

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
------------------------------

RE: Excel formula escape character

GopalBhaire — Tue, 24 Mar 2020 11:58:00 GMT

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

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