Vlookup being interpreted as a variable for me. I have this query: =IFERROR(VLOOKUP(M$currentRowNumTerminatedUsers$, 'All Users'!$H2:$H826, TRUE, FALSE),"Successfully Removed")

Forum|Forum|4 years ago
June 22, 2022
1 reply
98 views

$currentRowNumTerminatedUsers$ is a legit variable but it thinks that $H2 is a variable as well which it isn't. It is an Excel cell. How do I escape that character? Thanks.

A

Automation Anywhere Team

Hello,

In A360 $ is considered as a variable which is the reason its shown as an invalid expression.

I request you to please use 2 $ so that variable is closed and it will not give you this error, replace $ with $$ everywhere and you will not get this error.

If you have any questions please let me know.

Thank you,

Prabhakar Jha

Sign up

Login to the Pathfinder Community