Dear All,
I am trying to generate a Financial Analysis report. However, I am facing some problems trying to bring Quarter values for analysis. the objective is to make the sheet as flexible as possible allowing the user to choose any period that he wants to see against each other.
Whenever, i choose Jan 09 or Jan 10 it works as I want it to
however when i choose the quarter it shows an error. I am uable to resolve it.
Please help.
Regards,
Last edited by Chimero; 03-19-2010 at 07:26 PM.
Any help will be appreciated. I am on a dead line this week with this. thanks in advance.
regards,
Dear All,
Still standing by... is it even possible?
regards,
Please correct the sample sheet. It is currently full of REF errors, broken links to the last sheet.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hi,
sorry about that.. i was only expecting you to look into the first choice.. please find the revised version attached....
regards,
Last edited by Chimero; 03-18-2010 at 12:48 PM.
1) Create a "table" named range of the possible values in the INPUT-2010 sheet. Name the range CY_Table and give it a refers to of:
='Input- 2010'!$F$16:$V$20
2) Create a "table" named range of the possible values in the INPUT-LY sheet. Name the range LY_Table and give it a refers to of:
='Input- LY'!$F$4:$U$8
3) Fix the titles in INPUT-2010 for the quarters, they need to indicate 2010.
4) In J7 enter this formula
=IF(L8>0,L7/L8,0)
5) In L7 enter this formula, then copy it down to L8:
=IF($I$4="", "",IF(ISNUMBER(MATCH($I$4, LY_LItems, 0)), INDEX(LY_Table, MATCH($E7, LY_LItems, 0), MATCH($I$4, LY_Mths, 0)), INDEX(CY_Table, MATCH($E7, CY_LItems, 0),MATCH($I$4, CY_Mths, 0))))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hi Bro,
I tried working with the formula that you sent me. However, i am finding an error maybe i am doing something wrong here. Could you please take a look.
regards,
1) Fix the quarters on sheet2 like I said before, S15:V15 need to list 2010.
2) Then use this, small error in the first one, not sure why it even worked for me...
=IF($I$4="", "",IF(ISNUMBER(MATCH($I$4, LY_Mths, 0)), INDEX(LY_Table, MATCH($E7, LY_LItems, 0), MATCH($I$4, LY_Mths, 0)), INDEX(CY_Table, MATCH($E7, CY_LItems, 0),MATCH($I$4, CY_Mths, 0))))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Has anyone ever told you that you have the brains of 10 rocket scientists??? Oops seems like you already know
You rock big time, man. Thanks for this. You just saved my life.
Last edited by Chimero; 03-19-2010 at 07:25 PM.
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks