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
-- ---------------------------------------------------------------------------------- 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
