The XLOOKUP function in Google Sheets allows you to search in any direction, return multiple results, and gracefully handle missing values.

INDEX & MATCH are two separate functions in Google Sheets that, when combined, allow you to look up values both vertically and horizontally

Visualise and interpret percentage changes from week to week or month to month in Google Sheets

The INDEX function in Google Sheets, when used in conjunction with other functions can easily compete and excel compared to VLOOKUP.

The VLOOKUP is one of those well-known functions everyone’s heard of, yet it’s still somewhat of an enigma.

The VLOOKUP function is unquestionably in my top 5 most used functions.