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")

  • 22 June 2022
  • 1 reply
  • 44 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.

image


1 reply

Userlevel 6
Badge +9

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