top of page
Apr 26 min read
XLOOKUP Function in Google Sheets
The XLOOKUP function in Google Sheets allows you to search in any direction, return multiple results, and gracefully handle missing values.
3190
Nov 25, 20234 min read
How to Use INDEX and MATCH for Flexible Lookups in Google Sheets
INDEX & MATCH are two separate functions in Google Sheets that, when combined, allow you to look up values both vertically and horizontally
1,0050
Oct 12, 20234 min read
Analysing Percentage Changes with Google Sheets Formulas and Conditional Formatting
Visualise and interpret percentage changes from week to week or month to month in Google Sheets
1,2410
Aug 13, 20225 min read
INDEX Function in Google Sheets
The INDEX function in Google Sheets, when used in conjunction with other functions can easily compete and excel compared to VLOOKUP.
5120
Jul 30, 20224 min read
VLOOKUP Function in Google Sheets
The VLOOKUP is one of those well-known functions everyone’s heard of, yet it’s still somewhat of an enigma.
2600
Jul 17, 20223 min read
How To Return Multiple Columns with VLOOKUP and Data Validation
The VLOOKUP function is unquestionably in my top 5 most used functions.
3,1070
bottom of page