top of page


Mastering the FILTER Function in Google Sheets
The FILTER function in Google Sheets is one of the most powerful and versatile tools for dynamically working with data.
Jul 3, 20255 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.
Apr 2, 20246 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.
Jul 30, 20224 min read


How To Return Multiple Columns with VLOOKUP and Data Validation
The VLOOKUP function is unquestionably in my top 5 most used functions.
Jul 17, 20223 min read
bottom of page
