Formulas Articles

how to use lookup in google sheets

How to Use LOOKUP in Google Sheets (Easy Tutorial)

Google Sheets isn’t a database. But it can be used for basic database functions. The LOOKUP function can be used to find specific information within a set of data. Related functions include VLOOKUP and HLOOKUP.

How To Square In Google Sheets

How To Square In Google Sheets (Very Easy)

Today, we’re going to look at something fairly easy to do in Google Sheets: square! Squaring a number means multiplying that number by itself. The square of 5, for instance, is 5*5=25. Google Sheets has

Using OFFSET When the Address of a Cell is not Previously Known

How to Use the OFFSET Google Sheets Function

The OFFSET Google Sheets function is quite an under-used function. This is mainly because a lot of people don’t understand the purpose behind the function, or how it can be effectively made use of. In

google sheets compare two sheets

How to Compare Two Sheets in Google Sheets

Ever tried comparing the contents of two different Google Sheets to find discrepancies? If they’re small worksheets with a few rows and columns of data, it might not be that tough. With larger amounts of