top of page


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
352
0


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
296
0


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
3,264
0
bottom of page