What is the column index number in VLOOKUP?
In this article, we explain how to use the column index number in VLOOKUP functions in Excel and provide some examples.
Work / School
Why Excel Crashes When Deleting Rows
Does your Excel crash when you delete rows? We explain why this happens and how to fix it. (Article, 10 min)
MAXIFS without Arrays in Excel
Don’t have MAXIF or MINIF as standard functions in your Excel? Tired of array formulas slowing down your workbooks? We provide a simple solution. (Article, 5 min).
Is the Hunger Games a children’s novel?
Why does a children’s book like The Hunger Games feature so much violence? (Article, 5 min)
How to Get Better at Excel
Are you good at Excel but want to know how to become a master? In this article, we discuss how to complete your training. (Article, 5 min)
How to Unpivot Data in Excel Using Formulas
In this article, we explain how to unpivot (or melt) data in Excel using formulas (Article, 10 mins).
Alternatives to Pivot Tables
Pivot Tables are the best…until they’re not! We show you the alternatives in this installment of our Excel series. (Article, 10 min)
Beyond VLOOKUPs: How to use MATCH, INDEX-MATCH, and XLOOKUP
The IRH team continues our Excel series by discussing functions to replace your VLOOKUPs. (Article, 5 min)
The Benefit of Your Job You Might Be Missing
Your salary might cause you to underestimate the value of your job. Here’s why. (Article, 3 minutes)