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

  • 22 June 2022
  • 1 reply

$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.


1 reply

Userlevel 6
Badge +10



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