I have following code to check does MYDATA retrun 0 from index 4.
I got false result, even I have return value is 0.

IF(VLOOKUP("MYDATA", MYNAME, 4) = 0, "TRUE", "FALSE")

Am I right?

If mydata return value zero if should execute "TRUE",
It executea "FALSE" if it return non zero value.

Please let me know if I am wrong.

Any infromation is great appreciated,