
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 MoreJanuary 8, 2020
Oh, how I wish I’d had the fortune of the new Excel XLOOKUP function back in my accounting days. The
Read MoreJune 12, 2013
Last week I had an email from Mike asking how he can lookup a suburb in a range of columns
Read MoreNovember 23, 2011
What say you want to find the percentage increase or decrease for the last value in a list compared to
Read MoreApril 30, 2011
The Excel CHOOSE function is not much use on its own, but when you nest it with other functions it
Read MoreFebruary 1, 2011
A little while ago I showed you how to do a lookup to the left using the INDEX and MATCH
Read MoreDecember 3, 2010
In this tutorial, we'll dive into the powerful Excel INDEX and MATCH functions, which are essential for manipulating and analyzing
Read MoreNovember 26, 2010
The Excel HLOOKUP formula is just like the VLOOKUP formula, only the table you are looking up is laid out
Read More