I have a VLOOKUP formula excel that looks like this: VLOOKUP(“BE”&E2;[external excel file]!$B;$W;3;false)
How can I use this in Uipath? I know I need to use , instead of ; but I am struggling with the “BE” part. As Uipath interprets it as a string value and it is not concatenating the “BE” with the E2 cell right now.
Thanks in advance for taking your time.