All articles with 'vlookup or index+match' Tag
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 »
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 »