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 with Formula
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 <steveweave...@comcast.net> wrote:
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,"MMMM"),'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<steveweave...@comcast.net> wrote:
>> Hi,
>> Can some one help me to create a formula in excel. Using the attached
>> file, please refer to the "Monthly IS" tab, column D. I need help
>> writing a formula that will:
>> 1. retrieve the appropriate value from the "2011 Actual" tab based on
>> the month shown in "Monthly IS" tab, cell J3.
>> 2. retrieve the appropriate value from the "2011 Forecast" tab based
>> on
>> the month shown in "Monthly IS" tab, cell J3.
>> Thank you for your help.
>> Steve
>> IS Example.XLS
>> 640KViewDownload- Hide quoted text -
- Show quoted text -
--
----------------------------------------------------------------------------------
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
--
----------------------------------------------------------------------------------
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