19 Google Sheet Tutorials

I'll show you how to easily find a specific value in a range using two powerful formulas: VLOOKUP and INDEX MATCH. 

With VLOOKUP, we can search for a value in a column and retrieve information from the same row. 

I'll explain how to set it up and why the "false" parameter is important. Then, I'll introduce INDEX MATCH, which allows us to search for a value in one column and retrieve information from another column.

 I'll demonstrate how to use it to find a name based on a number and vice versa. This technique is incredibly useful when you need to look up information based on a specific value. 

Plus, I'll share a neat trick to make the search even more dynamic. So, let's dive in and master these versatile formulas together! 🚀

Great use of SPINTAX.  Get the Google Sheet Add-on; SPINTAX for free.

Automatically copy a spreadsheet tab to a whole new spreadsheet file, get the url of that new sheet, and make sure the new file is values only. no formulas. A member asked this question and I'm happy to answer it, code it, and let you in on the answer in this short video.

Learn how to add multiple rows to your google sheets by hand, and automatically. 

Make your VLOOKUP formulas flexible and your data move-able with this trick.

Now you can select multiple options in a dropdown. Hip Hip Hooray!

Analyze sales with COUNTUNIQUEIFS Formula. 

Adding to the Form Automations:
Allow User to Reopen form without Apps Script access
Set Limit in a Sheet, not in Apps Script
Set Limits for different Forms

This tool will allows you to share multiple links on your social media.

Find the first value in a row.