If you're using Excel and you’ve already learned how to use INDEX MATCH, you’re well on your way to becoming proficient with Excel lookups.  What INDEX MATCH MATCH offers you is a more powerful version of the formula.  Instead of just a vertical lookup, INDEX MATCH MATCH allows you to perform a matrix lookup, which ... Continue Reading >>

108 Tips for New MBA Students

It’s been two months since I graduated from business school, and I still have one month before I start my new full time job.  During this pre-employment period, I have not used my alarm clock once.  I play a lot of tennis, binge watch television shows, and even took a two week trip to Europe.  ... Continue Reading >>

How to Use HLOOKUP

HLOOKUP is essentially the horizontal version of VLOOKUP.  The primary reason for using HLOOKUP in Excel is for when you have key data points arranged horizontally across the top of your table.  This usually happens when you are dealing with time series data; people have a tendency to list lookup values horizontally with this type Continue Reading >>


When deciding between which vertical lookup formula to use, the majority of Excel experts agree that INDEX MATCH is a better formula than VLOOKUP.  However, many people still resort to using VLOOKUP because it’s a simpler formula.  One major driver of this problem is that most people still don’t fully understand the benefits of switching ...

My UCLA Anderson MBA Class Schedule and Notes

One thing that most MBA programs do a poor job of is providing useful, academic reference material after you graduate.  All business schools have great alumni networks and recruiting resources, but the availability of intellectual resources is significantly lacking.  It's understandable that professors want to keep the material they've taught or created from being widely ...


VLOOKUP MATCH is one of several possible lookup formulas within Microsoft Excel.  This tutorial assumes you already have a decent understanding of how to use VLOOKUP.  If you do not, please click here for a beginner’s tutorial on VLOOKUP. Objective VLOOKUP MATCH is an improved variation of your basic VLOOKUP or INDEX MATCH formula.  Using VLOOKUP MATCH ...

How to Learn Excel

Instructor with Students in Computer Lab

The majority of people who are really good at Microsoft Excel will tell you that they gained their knowledge simply through experience.  When I was a management consulting analyst, I’d frequently be given tasks that I thought were impossible with a spreadsheet; the process of coming up with an Excel solution was what really established ...