#index

Note: screenshots and examples were taken using Microsoft Excel 2013, however older versions can be used.

Tags

No tags yet.

Random selection from a list in 3 steps!

Ever needed to perform some testing of random sampling? How did you go about selecting items at random from a list? Read on as I walk thro

VLOOKUP VS INDEX-MATCH

I've covered how to use VLOOKUP and INDEX-MATCH and their limitations, if any. To recap, I've created a venn diagram to show the sim

INDEX-MATCH

INDEX-MATCH is more flexible and powerful than VLOOKUP as it doesn't have the limitations of VLOOKUP. It is a combination of two formula

Mastering VLOOKUP

VLOOKUP is probably one of the most commonly used but hated formulas. Having broken down the formula for you, let's learn it right for o