Hi,I want to use VLOOKUP formula in write into worksheet excel action in Appian RPA. The catch is I am passing all excel related values from interface to the bot (so all variables are set having values for lookup value, table range, column index etc.), therefore if I want to write the formula it should be in quotes like this --> "VLOOKUP(A1,Sheetname!A2:C12,2,FALSE)", this may work for hardcoded values but if I want to put my variables in this formula, it may not be possible as this is within quotes. For e.g. I can't replace A1 above with pv!lookupvalue as entire formula works within quotes.So how do I construct this formula in RPA to get these dynamic values from variables?
Discussion posts and replies are publicly visible
Ignore the question. Wasn't concatenating formula structure correctly with variables, after concatenating correctly with variables it got fixed.