January 8, 2020
Excel XLOOKUP Function
Oh, how I wish I’d had the fortune of the new Excel XLOOKUP function back in my accounting days. The
Read More
June 12, 2013
Excel Find Column Containing a Value
Last week I had an email from Mike asking how he can lookup a suburb in a range of columns
Read More
November 23, 2011
Cool INDEX Function Trick
What say you want to find the percentage increase or decrease for the last value in a list compared to
Read More
April 30, 2011
Excel CHOOSE Function
The Excel CHOOSE function is not much use on its own, but when you nest it with other functions it
Read More
February 1, 2011
Excel VLOOKUP to the Left Using CHOOSE
A little while ago I showed you how to do a lookup to the left using the INDEX and MATCH
Read More
December 3, 2010
INDEX MATCH Functions in Excel
In this tutorial, we'll dive into the powerful Excel INDEX and MATCH functions, which are essential for manipulating and analyzing
Read More
November 26, 2010
Excel HLOOKUP Formulas Explained
The Excel HLOOKUP formula is just like the VLOOKUP formula, only the table you are looking up is laid out
Read More