I´m working on an automation that interacts with some excel files who uses a VLOOKUP formula with dynamic values and linked to an external network file. The following value is being assigned to a variable and works fine, but the problem is that when i add “=” to it. The excel file don´t recognize it as a formula and ask to repair th file. I´ve tried adding the “=” directly to the string bellow and also concatenating it to a variabale: “=”+Vlook_variable. any ideas?
“VLOOKUP(”+Letter+“4;'C:\Users\RPA\2020\13. DIR"+dirMonth+”[00. DirA.xlsx]3- From x To’!$L:$O;4;0)"
The formula without the = is written inside excel without problem and if i add the = manually it works as expected. But i can´t make it set the = at once through the RPA automation.
it generates the following formula : VLOOKUP(M4;‘C:\Users\RPA\2020\13. DIR\04. April[00. DirA.xlsx]3- From x To’!$L:$O;4;0).
Hi @HareeshMR,
this is exactly what i have inside the spreadsheet and working when i manually add the ‘=’: =VLOOKUP(M4;‘C:\Users\RPA\2020\13. DIR\04. April[00. DirA.xlsx]3- From x To’!$L:$O;4;0)
the RPA write cell the “VLOOKUP(M4;‘C:\Users\RPA\2020\13. DIR\04. April[00. DirA.xlsx]3- From x To’!$L:$O;4;0)” nicely
but i have to manually add the ‘=’
the external network file i mean is because the official directory is a network dir, something like \server\process\2020\13. BP\04. April[00.Assumptions.xlsx]3-From x To in place of C:\Users\RPA, that is the local test.
I´ve found what was generating the problem with this vlookup formula. The semicolon ( ; ) was creating the error. Changing it to comma (,) solved it. Now is working beautifully.