$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.
Question
Vlookup being interpreted as a variable for me. I have this query: =IFERROR(VLOOKUP(M$currentRowNumTerminatedUsers$, 'All Users'!$H2:$H826, TRUE, FALSE),"Successfully Removed")
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.