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

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,

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

Hi Souris,

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

try using the fourth lookup parameter which determines if an exact match is
to be returned:

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

If the fourth parameter is omitted, an approximate match is returned.


See Excel help on VLookup for assistance with this additional parameter.


---
Regards,
Norman



"Souris" wrote in message
...
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,

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

Thanks millions,

It works,



"Norman Jones" wrote:

Hi Souris,

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

try using the fourth lookup parameter which determines if an exact match is
to be returned:

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

If the fourth parameter is omitted, an approximate match is returned.


See Excel help on VLookup for assistance with this additional parameter.


---
Regards,
Norman



"Souris" wrote in message
...
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,