81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

This course is not available for free users. Please purchase a subscription to enroll in this course and view its contents.

Formula Combinations

22 Tutorials

2 hours and 35 minutes

Powerful Google Sheets formula combinations. Individual formulas can combine to do very powerful things. My favorites are INDEX/MATCH and UNIQUE/TRANSPOSE and IF/ISBLANK

Google Sheet Formula Combinations: Powerful Tools for Better Data Management
Are you tired of manually organizing and analyzing data in Google Sheets? Do you find yourself spending hours on tasks that could be done with a single formula? If so, then it's time to learn about the powerful Google Sheet formula combinations that can save you time and effort.

In this section, we'll explore some of the most useful formula combinations that you can use in Google Sheets, including INDEX/MATCH, UNIQUE/TRANSPOSE, IF/ISBLANK, AND/OR in IF

I also have tutorials that include sorting filters, and checkboxes.

With these tools at your disposal, you'll be able to streamline your data management tasks and become more efficient with your work.

Google Sheet Formula Combinations
Google Sheets offers a range of formulas, that on their own are useful, but also can be combined to create superhuman formulas.

By combining individual formulas, you can create a more complex formula that can handle multiple tasks in one cell.

Here are some of my favorite formula combinations that I use on a regular basis:

INDEX/MATCH
If you're familiar with VLOOKUP, then you'll love INDEX/MATCH. This formula combination is more flexible and easier to use than VLOOKUP, and it's perfect for finding specific values in large data sets. With INDEX/MATCH, you can easily retrieve data from a table based on a specific criteria.

To use INDEX/MATCH, you'll need to specify the range of data that you want to search, the column that contains the data you want to retrieve, and the criteria that you're searching for. The formula looks like this: =INDEX(range, MATCH(criteria, column, 0), column_number)

UNIQUE/TRANSPOSE
The UNIQUE/TRANSPOSE formula combination is perfect for creating lists of unique values from a large data set. With this formula, you can easily remove duplicates and create a condensed list of unique values.

To use UNIQUE/TRANSPOSE, you'll need to specify the range of data that you want to search. The formula looks like this: =TRANSPOSE(UNIQUE(range))

IF/ISBLANK
The IF/ISBLANK formula combination is useful for checking if a cell is blank or not. With this formula, you can specify a value to return if the cell is blank and a different value to return if the cell is not blank.

To use IF/ISBLANK, you'll need to specify the cell that you want to check. The formula looks like this: =IF(ISBLANK(cell), value_if_blank, value_if_not_blank)

Example Videos
Here are some example videos that demonstrate how to use these formula combinations:

Use Index Match when you want Vlookup
If you find VLOOKUP a difficult formula to understand, this formula combination might be better. It's also much more flexible than VLOOKUP. Index/Match is the best. It's one of my favorite formula combinations.

How to Make a Quick CRM w/ Dashboard
Build a Customer Relationship Manager right inside a Google Sheet. Track your customers, your sales progress, and your revenue in an easy to create dashboard.

How to Use AND(), OR() in IF() in Google Sheets For Multiple Criteria
One of the most simplest and useful formula combinations is using AND() and OR() inside of an IF statement. You can use this when you want an IF formula to have multiple criteria.

Make a Quick Pipeline (For Sales and More)

Create a sales pipeline quickly in Google Sheets.

How To Sort A Filter
This will allow you to analyze and organize your data. Add SORT to the inside of the FILTER formula and you have a sweet little interactive list.

Magical Things You Can do with Checkboxes in Google Sheets
Turn your sheets into web apps with interactive checkboxes. Make your sheets' UI better with more interaction.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Better Sheets has got each key formula crucial to enhance your Google Sheets competence

22Tutorials

If you find Vlookup a difficult formula to understand, this formula combination might be better. It's also much more flexible than Vlookup. Index/Match is the best. It's one of my favorite formula combinations.

1

Build a Customer Relationship Manager right inside a Google Sheet. Track your customers, your sales progress, and your revenue in an easy to create dashboard.
One of the most simplest and useful formula combinations is using and and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.
Create a sales pipeline quickly in Google Sheets.
This will allows you to analyze and organize your data.

5

Create a slug maker inside your sheet. We'll take any title with any case, even if it's wrong. Our sheet template will lower case the whole line, and replace any spaces with hyphens. This way we can enter any kind of title we want and get a hyperlink slug out for use in blogs or cataloging.
Turn your sheets into web apps with interactive checkboxes. Make your sheets' UI better with more interaction.
Calculate Return on Ad Spend with a formula combination. Bonus: create a more elegant solution in Apps Script using JsDoc syntax to create an autocomplete native function. We use the formula combination of Concatenate / Round to create the ratio, but in Apps Script we do it a whole lot better.
Create the Ultimate Headline Writer: Unleash the Power of Google Sheets and OpenAI's API / GPT-3.5-Turbor to Create Compelling Website Headlines. Write in different styles, using different parameters to make the ultimate headline writer for an agency or for your own business.
One of the most simplest and useful formula combinations is using and and or inside of an if and what happens is we want to use this when we want an if formula to have multiple criteria.
Create a little web app, or a tool inside of Google Sheets that can take any text input and give us the correct case we want. It can do Title Case or Sentence Case. It can do UPPER and lower case as well.

I added a little apps script to it that will check only one of the options. Check out the Radio Button Apps Script in another video.
Create a growing flower pot from checkboxes with this bountiful formula combination. Members get free access to the sheet in the video.
4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.

13

Discover effective methods to handle misspelled duplicates in Google Sheets using formulas without destroying your data. Search and find duplicates that are spelled differently.

Unveiling the Art of Taming Misspelled Duplicates: A Harmonious Symphony of Google Sheets Tricks and Tips

Embark on a captivating journey as we unravel enchanting secrets in this video guide.

Discover an ethereal dance of formulas that transcends the limitations of Google Sheets' native features, gracefully addressing the conundrum of misspelled duplicates. 

Delve into the profound intricacies of the issue, where statuses and names intertwine, inviting chaos into your CRM or meeting records. 

Witness the mesmerizing revelation of unorthodox yet elegant techniques that preserve your data's essence without sacrificing its integrity. Unveil the hidden world of the duplicate detector, where rows are harmoniously synchronized, leaving no spelling errors unnoticed. 

Prepare to be enchanted by the sublime artistry of equals unique, a symphony of transformation that transforms hundreds or thousands of rows into a carefully curated masterpiece. Immerse yourself in this poetic quest and unlock the mystique of finding truth amidst a sea of missteps.
There are surprisingly few times you want to have blank cells, or even create blank cells. In this video I'll show you the good reasons you want blank cells.
find out how to show the total number of data rows available in a sheet.
Figure out who won a game of tic tac toe. inside a Google Sheet. Great for teachers and educators.

17

How to figure out a percentage score when our reporting numbers are a formatted in a particular way. In this case we have a score and then a slash and then the total possible score in a single cell. We go through each option of solution and try to derive a solution that is both useful in the exact situation and possibly useful for other problems too.

We find that the Query formula and other solutions are inflexible or time intensive. We want a solution that does actually solve the problem at hand, in a quick way, and also is easy to edit and flexible to solve other problems.
Learn how to find duplicates with a simple formula in Google Sheets.

19

Boost Your Productivity with a Priority Matrix: Learn How to Prioritize Your Tasks and Achieve More! Join us in this different kind of video and discover the best tips and tools to create a two by two grid that helps you determine what's important and urgent. Perfect for daily planners, long-term projects, decision-making, gift-picking, and more! Don't miss out on this collaborative and time-saving approach! 

Great use case for the formula combination of JOIN/FILTER.
Wanted to share with members this course outline I am using for my own course making process. I outlined the course then added a bunch of cool little stats to help see my progress and keep me on a certain pace of video creation. 
Discover the Secret Formula to Insert a Quote Randomizer in Your Sheet! | Learn how to use a simple one-formula combo to get a random assortment of quotes in your sheet. Change the quote every time you open the sheet. Watch now and amaze your friends! 

How to insert a quote generator or a quote randomizer inside your sheet. Without using Apps Script.