I aim to put the following formula into an Excel Cell (E4) with the function “Write Cell”, by which I can perform Vlookup with data from another Excel file (EC_Policy (as at Mar).xlsx). However, Uipath couldn’t recognise the formula as it said end of expression expected. Could any help check what is missing? The formula itself is fine… Many thanks!
“=IF(IFNA(VLOOKUP(VALUE(E4),‘EC_Policy (as at Mar).xlsx]Sheet1’!$A:$A,1,FALSE),)=0,” “,“EC”)”
Okay , So I also Tried Copy paste from notepad - I got the same Error, But then i removed the first and the last double Quote and Re Type them it worked .