3 Advanced Ways to Use the INDEX Formula

The INDEX function is for returning a cell’s content or specific value, which is specified by row or column offset. Here is the syntax of INDEX():

INDEX(range, row_num, column_num)

Below are three video tutorials for advanced users. In these tutorials, I show you the different ways you can make use of the INDEX function to create fun and useful things with Google Sheets.

Adding a Foodcourt to Doc's Virtual Mall | Sheet Improvement!

In this special video tutorial on sheet improvement, I take an existing Google Sheet and make it better. After all, we’re Better Sheets, right? For this tutorial, I’ll work on Doc’s Virtual Mall, which is taken from Elliot’s Virtual Mall. It has fun things like an elevator, which you use to enter the mall. You can go to the different levels: Launch, Books, Mentors, No-Code, Newsletters, and Makers. Some fun stuff: In the Books level, you can even claim a spot for your own store if you’re selling your own books!

In this tutorial, I also give you ideas and use cases for creating this Virtual Mall. Not only are you going to learn how to create your own Virtual Mall, but you are also going to learn the different things you can use them for. Learn about all the good stuff with this sheet improvement tutorial by watching the video below.

Sheet Stories / Video Notes + ADDED: Email Notifications

Add video notes through Custom menu, complete with video thumbnails. To make it even better, I’ll show you how you can set up email notifications by using Google Apps Script. Recieve email notifications so you never miss out on what’s happening in your sheet.

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

In this tutorial, I’ll show you how you can delete videos that are in your Google Sheet for more than 24 hours. This is something similar to Instagram Stories, where you only share a video that’s viewable for only 24 hours. That way, you can keep your sheet updated with only the most recent data that you want to share.

For free tutorials featuring this formula, you can check out these other videos: