Huh :|
Don't you have any problem with your data (like text instead of
figure) on the last position ?
It works perfectly on my computer

On 25 août, 12:13, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote:
> Dear Frederic,
>
> This function LOOKUP(9^9,A:A) is not working..............
> We are unable to find Adject Output, it is showing #N/A error..
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Thu, Aug 25, 2011 at 2:36 PM, Frederic LE GUEN <fleg...@gmail.com> wrote:
>
>
>
> > Use the function LOOKUP(9^9,A:A)
> > 9^9 = 387420489
> > Because this value is not in your range A:A, Excel return the last
> > value of  your range.
>
> > Then, you copy/paste this formula 40 times and you just have to change
> > the column's reference.
> > And if the hearder of your report worksheet is equal to the
> > worksheet's name, you can use the indirect function
>
> > On 24 août, 19:45, Clint Stevens <clintontstev...@gmail.com> wrote:
> > > Help: I have 40 spreadsheets in one workbook. I update the
> > > spreadsheets daily. I want the last row (Values) on all 40
> > > spreadsheets copied to a summary sheet everyday after I update the
> > > data. How do you do this? After the data is summarized and I review it
> > > I will then delete the data in the summary sheet and repeat the
> > > process the following day.
>
> > > Thx, Clint
>
> > --
>
> > ---------------------------------------------------------------------------­-------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel- Masquer le texte des messages 
> >précédents -
>
> - Afficher le texte des messages précédents -

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to