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.
top of page
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
9740
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,1520
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.
5070
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.
2580
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,0790
bottom of page