Learn when FILTER beats XLOOKUP, when it does not, and how to handle multiple matches, nth items, and multi-condition lookups with clear steps.

Navigating the labyrinth of Excel functions can sometimes feel like deciphering a foreign language, especially when you’re knee-deep in data and just need that one elusive piece of information. If you ...

I still remember the first day I figured out how to run a vlookup command in Excel; I was sitting at my coffee table wondering what the point of this silly little command was. Once I realized its ...

Learn how to use Excel’s XLOOKUP to return data from non-adjacent columns, saving time and making your spreadsheets more ...

Learn how to use XLOOKUP in Excel to return multiple columns easily, faster, and more efficiently than traditional VLOOKUP.

Following on from our time saving Excel shortcuts, we continue offering updated advice for the time-sensitive spreadsheet enthusiast. Back in 2013 John Gagnon wrote a very popular post about VLOOKUP ...