A simple vlookup formula such as this to lookup the item in the IS sheet when
you know the column should do it. You can then use edit/replace to change the
formulas. A one click macro could do it all.
=VLOOKUP(J9,'2011 Actual'!B2:AG331,10,0)
From: Steve Weaver
Sent: Friday, August 19, 2011 11:53 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help with Formula
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
--
----------------------------------------------------------------------------------
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
