Formula and Function

[Bernd Werthenbach]

Hi there, I need help with a function/formula. Please check the sheet "overview" in the attached file. Everything is in order, except for the column "MONTH/Budget". In the drop-down list the "month 03" was selected (pls. see attached file). In "Actual" the correct monthly amount is shown for month 03. However, in Budget the cumulative amount for months 01, 02, 03 is calculated? It should only be the amount for month 03 = 1,833. Same applies to the other line items below (expenses, profit etc.). Thank you!!!  

MONTH	Budget	Actual	Difference
Operating Revenue	$                       5,500.00	$                       1,900.00	$                     (3,600.00)
Non-Operating Revenue	$                                    -	$                                    -	$                                    -
Total Revenue	$                       5,500.00	$                       1,900.00	$                     (3,600.00)
Total Expenses	$                       3,362.50	$                           750.00	$                     (2,612.50)
Profit	$                       2,137.50	$                       1,150.00	$                        (987.50)

[#2]

Try using a formula like this: =OFFSET(MonthlyBudget!$A$19,,INT(RIGHT($C$4,2)),,)

or maybe this:

=INDEX(MonthlyBudget!$A$7:$M$100,MATCH(Overview!$B$21,MonthlyBudget!$A$7:$A$100,0),MATCH(Overview!$C$4,Months,0))

Please see attached file.

[#3]

Thank you so much. I appreciate your support!

[#4]

Bernd-

Always happy to help!  You're quite welcome.  Please feel free to post back if you need additional help or clarification!