There you go
=SUM(INDIRECT("'2011 Actual'!$C$3:"&ADDRESS(3,MATCH("*"&TEXT('Monthly
IS'!$J$3,"MM/YY")&"*",'2011 Actual'!$A$1:$N$1,0
On Aug 26, 2:28 am, Steve Weaver wrote:
> Thank you Sam for this suggestion. However, the formula doesn't provide
> the results that I am looking for.
>
> The fo
I meant to say you can NOT use that part of the formula for the vlookup for
Actual but you can use the match part for the Forecast sheet.
-Original Message-
From: Don Guillett
Sent: Saturday, August 20, 2011 1:08 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Re: Help
You can use this part of the formula for the simple vlookup
COLUMN'=MATCH(TEXT($J$3,"MM/yy"),'2011 Actual'!$A$1:$X$1,0)
On Aug 20, 6:43 am, Steve Weaver wrote:
> Sam, thank you so much . . . the formula works GREAT!!!
>
> Steve
>
> On 8/20/2011 1:05 AM, GoldenLance wrote:
>
>
>
> > Use =INDIRECT(
Sam, thank you so much . . . the formula works GREAT!!!
Steve
On 8/20/2011 1:05 AM, GoldenLance wrote:
Use =INDIRECT("'2011
Forecast'!"&ADDRESS(28,MATCH(TEXT(J3,""),'2011 Forecast'!$A$2:$X
$2,0))) in Monthly IS, range F9
Steve, sure you can replicate this for all your cells.
Regards,
Sa
Use =INDIRECT("'2011
Forecast'!"&ADDRESS(28,MATCH(TEXT(J3,""),'2011 Forecast'!$A$2:$X
$2,0))) in Monthly IS, range F9
Steve, sure you can replicate this for all your cells.
Regards,
Sam Mathai Chacko (GL)
On Aug 19, 9:53 pm, Steve Weaver wrote:
> Hi,
>
> Can some one help me to create a fo
mula. please help. thank you. regards. Harris
>
>
>
> -- Forwarded message --
> From: harris a
> Date: Aug 2, 9:29 pm
> Subject: $$Excel-Macros$$ Re: help with formula for report
> To: MS EXCEL AND VBA MACROS
>
>
> Hello Swapnil,
>
> Thank you.
Hello Swapnil,
Thank you. How do I copy the macro into by work file?
can anybody else help me with excel formula. thank you
regards
Harris
On Jul 31, 9:00 pm, Swapnil Palande wrote:
> Hi Harris,
>
> It may be possible to do this using formula. But I don't know how to do it
> using formula.
>
Hi Harris,
It may be possible to do this using formula. But I don't know how to do it
using formula.
You have to just change the range in given macro according to your data.
Regards,
Swapnil.
On Fri, Jul 31, 2009 at 7:52 PM, harris a wrote:
>
> hello
>
> thank you very much for the solution.
hello
thank you very much for the solution. But is it possible to have the
formula in excel rather than VB. excel formula would be help to me in
replicating. thank you. regards. Harris
On Jul 31, 3:16 pm, Swapnil Palande wrote:
> Hi Harris,
>
> Please find attached excel for solution to your pr
Hi Harris,
Please find attached excel for solution to your problem. Press update button
to run macro.
If you have any query let me know.
Best regards,
Swapnil.
On Fri, Jul 31, 2009 at 10:53 AM, harris a wrote:
> Hello,
>
> I am enclosing file <>. I need help in populating the report
> table
Hello Upendra & Serghei,
Thank you very much for the help. The solution provided by you was the
one i was looking for.
cheers
Harris
On Jul 30, 6:45 am, "Upendra Singh"
wrote:
> Hi Harris,
>
> Use the below formula in cell F20.
>
> Regards,
>
> Upendra Singh
>
> +91-9910227325, +91-9310760597
Hi Harris,
Use the below formula in cell F20.
=INDEX($C$6:$O$11,MATCH($D20,$C$6:$C$11,0),MATCH($E20,$C$6:$O$6,0))
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
T
Hi Harris,
Use the below formula in cell F20.
Regards,
Upendra Singh
+91-9910227325, +91-9310760597
-
There are 10 kinds of people: Those who understand binary and those wh
Hello Harris,
Please find attached a solution for your problem. Do confirm if this is what
you wanted.
Kind regards.
Serghei
Date: Wed, 29 Jul 2009 15:19:12 +0530
Subject: $$Excel-Macros$$ Help with formula
From: harris...@gmail.com
To: excel-macros@googlegroups.com
Hello,
14 matches
Mail list logo
