Time for another homework. You got a spreadsheet of department budgets and need to write a formula to get budget for a given department, month combination.
Assume your data is in the table named budgets, D18 has department and D19 has month values.
You can use any formula in Excel to get the answer. Let’s get creative and have fun.
Post your solutions in the comments section. GO!!!
Need a sample file? Get it from here.
Need a hint? Check out my 2D lookups article.
Want more homework problems? See this page.
The post Write a formula to get Department Budget for a Month [Homework] appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.
Original source: http://feedproxy.google.com/~r/PointyHairedDilbert/~3/gOtRcGzN2yk/