VLOOKUP | Spreadsheet Wise

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.

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

Jun 24, 202312 min read

Task List in Google Sheets with Kanban & Automated Status Tracking

Efficient task management is essential for maintaining productivity. This tutorial will explore a powerful solution to streamline your tasks

Dec 21, 20228 min read

How to Create Pivot Tables in Google Sheets

Pivot Tables are an efficient and powerful way to analyse large amounts of data and make meaningful insights with minimal effort

Aug 15, 20223 min read

How to Bulk Translate with Google Sheets

With Google Translate, you can translate anything, but did you know that you you can also achieve this using a Google Sheets Function?

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.

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.

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.