#indexmatch

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

Stop Moving! - Absolute Cell Reference

Copied a formula to another cell and noticed the result is not the same as the cell that you just copied? Read on to see how $ signs can pre

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