Group:  Microsoft Excel ยป microsoft.public.excel.worksheet.functions
Thread: how do i get exact matches in a vlookup fomrula

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

 Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

how do i get exact matches in a vlookup fomrula
shark1966 30.09.2006 03:25:01
in my vlookup formula, I am finding values that shouldn't have values are
returning the value for the closest match.
Re: how do i get exact matches in a vlookup fomrula
"Biff" <biffinpitt[ at ]comcast.net> 30.09.2006 04:11:06
Set the 4th argument to FALSE or 0:

=VLOOKUP(A1,B1:C10,2,FALSE)

=VLOOKUP(A1,B1:C10,2,0)

Biff

"shark1966" <shark1966[ at ]discussions.microsoft.com> wrote in message
news:E82D2E3A-D6D4-4273-A778-02ECD2ABF49F[ at ]microsoft.com...
[Quoted Text]
> in my vlookup formula, I am finding values that shouldn't have values are
> returning the value for the closest match.


Re: how do i get exact matches in a vlookup fomrula
shark1966 30.09.2006 13:13:01
That worked great! Thanks. I am now receiving #N/A where there are no values.
How can I force the N/A to 0???

"Biff" wrote:

[Quoted Text]
> Set the 4th argument to FALSE or 0:
>
> =VLOOKUP(A1,B1:C10,2,FALSE)
>
> =VLOOKUP(A1,B1:C10,2,0)
>
> Biff
>
> "shark1966" <shark1966[ at ]discussions.microsoft.com> wrote in message
> news:E82D2E3A-D6D4-4273-A778-02ECD2ABF49F[ at ]microsoft.com...
> > in my vlookup formula, I am finding values that shouldn't have values are
> > returning the value for the closest match.
>
>
>
Re: how do i get exact matches in a vlookup fomrula
Dave Peterson <petersod[ at ]verizonXSPAM.net> 30.09.2006 13:20:55
=if(iserror(vlookup(...)),0,vlookup(...))

If you're using xl2007:
=iferror(vlookup(...),0)



shark1966 wrote:
[Quoted Text]
>
> That worked great! Thanks. I am now receiving #N/A where there are no values.
> How can I force the N/A to 0???
>
> "Biff" wrote:
>
> > Set the 4th argument to FALSE or 0:
> >
> > =VLOOKUP(A1,B1:C10,2,FALSE)
> >
> > =VLOOKUP(A1,B1:C10,2,0)
> >
> > Biff
> >
> > "shark1966" <shark1966[ at ]discussions.microsoft.com> wrote in message
> > news:E82D2E3A-D6D4-4273-A778-02ECD2ABF49F[ at ]microsoft.com...
> > > in my vlookup formula, I am finding values that shouldn't have values are
> > > returning the value for the closest match.
> >
> >
> >

--

Dave Peterson

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net