Formulas Articles

SUM with INDIRECT
Formulas

How to Use the INDIRECT function in Google Sheets

There is a myriad of functions in Google Sheets, most of which are quite straightforward to understand. The INDIRECT function, however, is one of those Google Sheets functions that may not be that easy to

Workbook name and Sheet name
Formulas

How to VLOOKUP from Another Sheet in Google Sheets?

When working with multiple datasets across worksheets in Google Sheets, it can get quite frustrating and time-consuming to look up data between different sheets. Google sheets, however, provides a feature that saves you the trouble