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
