Menu
All articles with 'vlookup or index+match' Tag
{ 40 Comments }
Write a formula to get Department Budget for a Month [Homework]
Published on Mar 12, 2021 in Excel Challenges
![Write a formula to get Department Budget for a Month [Homework]](https://chandoo.org/wp/wp-content/uploads/2021/03/department-budget-2d-lookup-problem.png)
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.
Continue »{ 25 Comments }
VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01
Published on Aug 15, 2019 in Interview Questions, Learn Excel
This is part of our Excel Interview Questions series.
VLOOKUP or INDEX+MATCH? When you should use each function and why?
This is such a great question to ask in interviews. So in my first installment of Excel interview questions, let me answer it.
Continue »
