Moving Beyond Basics: Nesting VLOOKUP and MATCH Functions

Nesting a MATCH function within a VLOOKUP can enable you to eliminate manual adjustments to your VLOOKUP functions when working in spreadsheets with Excel.

Quick Percentage Change Calculation

A colleague taught me a trick to calculate percentage change quicker than the traditional way at the start of my last job. Below is the formula, it basically just cancels out steps that I’d done before, but for some reason I’d never thought to do it this way.

(Ending value/Beginning Value)-1

Example, last quarter I sold 100 units and this quarter I only sold 75, thus I had a decrease of 25, I can calculate the percentage change really quick.

(75/100)-1 = -.25 or a 25% drop.

This little trick works, and if you use it, you can save a lot of time in the long run.

For more math and Excel tips visit: www.infopresented.com