Write a formula to get Department Budget for a Month [Homework]
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.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« How to embed Excel files, calculators on your website? – Step by step instructions||What is XLOOKUP? 13 formula examples to really understand it »|