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