Re: $$Excel-Macros$$ entering Array formula in lookup function

2012-09-10 Thread Paul Schreiner
list!  Paul ----------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - __

Re: $$Excel-Macros$$ entering Array formula in lookup function

2012-09-08 Thread Sam Mathai Chacko
> I'm still having trouble inserting it as an array function. > >> > > >> > thanks, > >> > > >> > > >> > Paul > >> > > >> > ----- > >> > “Do all the good you can, > >> > By all the means you can, > >> > In all the w

Re: $$Excel-Macros$$ entering Array formula in lookup function

2012-09-08 Thread David Grugeon
> >> > thanks, >> > >> > >> > Paul >> > >> > - >> > “Do all the good you can, >> > By all the means you can, >> > In all the ways you can, >> > In all the places you can, >> &g

Re: $$Excel-Macros$$ entering Array formula in lookup function

2012-09-08 Thread Sam Mathai Chacko
; > > > > > Paul > > > > - > > “Do all the good you can, > > By all the means you can, > > In all the ways you can, > > In all the places you can, > > At all the times you can, > > To all the peo

Re: $$Excel-Macros$$ entering Array formula in lookup function

2012-09-07 Thread David Grugeon
--- > “Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > ----- > > > >

Re: $$Excel-Macros$$ entering Array formula in lookup function

2012-09-07 Thread Sam Mathai Chacko
an, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > ---------- > *From:* Sam Mathai Chacko > *To:* excel-macros@googlegroups.com >

Re: $$Excel-Macros$$ entering Array formula in lookup function

2012-09-07 Thread Paul Schreiner
l the people you can, As long as ever you can.” - John Wesley - From: Sam Mathai Chacko To: excel-macros@googlegroups.com Sent: Fri, September 7, 2012 1:26:28 PM Subject: Re: $$Excel-Macros$$ entering Array formula in l

Re: $$Excel-Macros$$ entering Array formula in lookup function

2012-09-07 Thread Sam Mathai Chacko
Shouldn't they be strings? =LOOKUP(A2,{0,1,2,3,4,5,6,7,8,9},{"#","#","#","#","#","#","#","#","#"}) Regards, Sam Mathai Chacko On Fri, Sep 7, 2012 at 10:37 PM, Paul Schreiner wrote: > Odd... > I seem to be suffering a temporary loss of cognitive function. > (can't think straight) > > I'm trying