Re: How do I remove the #div or N/A and make it 0 when using VLookup?

Tech-Archive recommends: Fix windows errors by optimizing your registry

It works "as-is" on XL2k also.........

Vaya con Dios,
Chuck, CABGx3


"JulieD" <JulieD@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:#gRc$6DQFHA.1500@xxxxxxxxxxxxxxxxxxxxxxx
> Hi
> your formula should do exactly what you request and it works when i test
it
> ... if you're using excel 2002 or excel 2003 can you spot what is wrong if
> you click on the cell with the formula and use tools / formula auditing /
> evaluate formula to step through it?
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ...well i'm working on it anyway
> "JeaneIsaac" <JeaneIsaac@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:2AAC17D3-7112-48CF-B795-FD53EA0357C3@xxxxxxxxxxxxxxxx
> >I have a very large work*** that I am using the following vlook up on
> >
> >
=IF(ISNA(VLOOKUP(trim($D5),Dataentry!$D$9:$P$1508,12,0)),0,VLOOKUP(trim($D5)
,Dataentry!$D$9:$P$1508,12,0))
> > I am using the results of the lookup for another calculation, so I
don't
> > want the return value from my look up to be N/A. Can you please tell me
> > how
> > to make it 0 instead of the N/A when there is no match in the lookup
> > ***.
> > Thanks
> >
>
>


.

Quantcast