Topics > Formula Combinations

49 Tutorials

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

49Tutorials

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.
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 simple checklist checker that shows us the first unchecked item in a task list.
Create a sales pipeline quickly in Google Sheets.
This will allows you to analyze and organize your data.
Using the ampersand and ARRAYFORMULA to combine two filters into a single column.
It's a common problem: combining two lists of scores to identify top performers using Google Sheets. We demonstrate how to sort data from two different ranges using the VSTACK function and also using curly brackets. Learn the step-by-step process to create a single, vertically stacked dataset that can be sorted effectively.
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.
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.
Learn how to harness Google Sheets' new multi-select dropdown feature in this tutorial. We'll guide you through setting up dropdowns that allow multiple selections, using search and filter formulas to analyze and display data efficiently. By the end, you'll be able to create dynamic reports and dashboards, streamlining your workflow and enhancing data management. Perfect for those looking to get the most out of Google Sheets' latest functionality!
Uncover the Magic of Regex Match! 🎩✨ Explore 200+ Examples at BetterSheets.co. Validate emails, detect hashtags, format data & more! Dive into the world of Regular Expressions. Start Your Regex Journey Now!

Use REGEXMATCHER to generate any REGEXTMATCH formula you want.
Learn a cool trick you can do with the ArrayFormula. If you don't know what the ArrayFormula does, I show you how to use it in the first few minutes of this video.  Then show you how to use it better.
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! 🚀
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.
I will show you how to create a hack to retrieve Instagram follower accounts from any Instagram page using import XML. I will explain the step-by-step process, including how to identify the XML, split it, and extract the follower account. Follow along and try it out yourself.
I need help to supercharge my YouTube channel! Are you struggling to find the best strategies to boost your YouTube channel's performance too? Let's see if Mr. Beast can help.


I start off this video with the idea to show beginners how to automate emails in their sheets, and also add a little bit of AI. Then half way through the video I have a question... can I write AI and then email myself everyday? We try to do that. So you get to see me struggle, and log, and debug. It's quite intense.


Learn more Automation: https://bettersheets.co/courses/spreadsheet-automation-101

Get the AI GPT-3.5 and GPT 4 code: https://bettersheets.co/tutorials/upgrade-google-sheets-openai-prompt-to-gpt-4

Better Sheets members can get the code and the sheet in the video below.
I'll show you how to create a motivational quote checklist that generates a random quote every time you check off a task. We'll start from scratch and create a formula that displays motivational quotes from a list of 100 quotes. The quotes can be easily expanded, and the checklist will update accordingly. This tool will add a touch of motivation and productivity to your day. Enjoy!
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.
Use Google Sheets to quickly find pages we can optimize. Using data directly from Google Search Console. Also check out the simple formula combination: AND() with IF()
Find out how many people attended each event even if they are double counted in attendee lists.
Learn how to import DropCatch data with 100,000 domains into a Google Sheet. Find out how to get a filtered list of domains with sheet in them. And how to generate ideas of what to build based on these found domains.

Leveraging Expired Domain Names for Google Sheets Business: The speaker discusses using expired domain names to create and sell Google Sheets templates or tools. He demonstrates how to find domain names related to 'sheets' and suggests creative business ideas around them.

Importing and Analyzing Data in Google Sheets: The process of importing CSV data into Google Sheets and manipulating it to find specific information (like domains containing the word 'sheet') is showcased. This highlights the versatility of Google Sheets in handling and analyzing data.

Idea Generation and Business Opportunities in Google Sheets: The speaker, Andrew Kamphey, provides several examples of how to generate business ideas using Google Sheets. He suggests various niches like WordPress-related spreadsheets, balance sheets for accountants, and even educational tools like math workbooks, demonstrating the wide range of potential applications for Google Sheets in various domains.
Create a growing flower pot from checkboxes with this bountiful formula combination. Members get free access to the sheet in the video.
Find out the results of YouTube Thumbnail A/B Tests with this YouTube Thumbnail Image hack we can do in Google Sheets.
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.
Someone asked about how to find all the permutations of text and I thought it was a perfect example to show you how to use Spintax add-on. Free for everyone.

→ Get Spintax
Created a tournament template with 4 automations. So tabs can be copied by a laptop, ipad, or mobile.
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.
4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.
Unlock the Secrets of SEO Meta Descriptions! Learn how to craft compelling meta descriptions using AI and Google Sheets. Boost your website's visibility and engage your audience. Dive into the world of effective SEO writing now! 
Walk through creating an awesome automatic word count tracker that's easy to use and motivates the writer to keep going. With AI generated quotes from famous writers, along with simple formulas to generate states along the way.
10 Things I Hate About Your Spreadsheets and how to fix them. Here is a list of 10 things you can do today to make your sheets more lovable.

The 10 Things I Hate about your Sheets
  1. Squeezed Rows
  2. Garbage Data
  3. Looks The Same
  4. Crazy Column Width
  5. Where’s Waldo 
  6. Of Results
  7. Too Many Clicks
  8. Instructions Unclear
  9. Eye Strain and Headaches
  10. Lazy Conditional Formatting
  11. Too Many Cells
Pick a raffle winner if you only have the names and number of tickets. And do it in one cell.
Got this question in the Facebook Group: How to count the number of numbers in a row. I saw two possible solutions mentioned in the comments and wanted to go through why those are okay but there is a much more flexible and better solution.
Get Kanye Quotes, Hogwarts Houses, Public Holidays, and more fun with API's in this 1 hour dive into Free APis available online and accessible in Google Sheets. 
API's here: freepublicapis.com
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.
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.
Figure out who won a game of tic tac toe. inside a Google Sheet. Great for teachers and educators.
Learn how to find duplicates with a simple formula in Google Sheets.
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.
Create a year progress bar to see how much of the year is gone. Great motivational chart to watch count up to 100%.