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,

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" <[email protected]> wrote in message
news:[email protected]...
>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,
>

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" <[email protected]> wrote in message
> news:[email protected]...
> >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,
> >
>
>
>