Create a Many to Many Database inside Google Sheets

In this video, I show you how to create a many-to-many database using Google Sheets. I demonstrate how to set up two tables, one for names and one for keywords, and then create a third table with dropdown menus that allow you to link names and keywords together. This is a useful tool for organizing information and making it easy to see the relationships between different pieces of data. Whether you're working with leads, contacts, or anything else, this method is a quick and efficient way to create a many-to-many database.
There are many possible uses for a many-to-many database in Google Sheets. Some examples include:
Organizing contact information: You can create a many-to-many database to store information about your contacts, such as their name, email address, phone number, and company. You can then link each contact to multiple keywords or categories, such as "client," "supplier," or "partner."
Managing tasks: You can use a many-to-many database to assign tasks to multiple people and track their progress. For example, you could link a task with the names of the people responsible for completing it, as well as the due date and status.
Tracking inventory: You can use a many-to-many database to keep track of your inventory and link each item with multiple categories or locations. For example, you could link an item with its name, SKU, supplier, and location in your warehouse.
Organizing events: If you are planning an event, you can use a many-to-many database to track the details of each event, such as the date, time, location, and attendees. You can also link each event with multiple keywords or categories, such as "conference," "meeting," or "workshop."
🔔 Subscribe for more free Google Sheets tips: th-cam.com/users/bettersheets?...
🕰️ Time Saving Tips, Tricks and Techniques
bettersheets.co/topics
🤖 Add AI to Your Sheets
bettersheets.co/courses/adven...
🚀 Tools and Templates For YOU:
Generate Google Sheets Formulas:
bettersheets.co/google-sheets...
100 Free Business Ideas - Lead Magnet, product, and business ideas you can make in a Google Sheet to validate your business ideas.
Free at bettersheets.co/tools/100-bus...
Tiny Sheets - Easily delete unnecessary rows and columns
Free Add-on: tinysheets.bettersheets.co/
Sheet Styles - Change your spreadsheets style to match your mood.
Get it now: sheet-styles.bettersheets.co/
Atomic Sheets - 100 Spreadsheet elements you can add to your spreadsheets immediately.
30 free: atomicsheets.com/
Generate REGEXMATCH formulas to clean data
bettersheets.co/regexmatcher
Generate SPARKLINE formulas to make cool charts inside of cells.
bettersheets.co/sparkliner
😎 Most Popular Tips and Tricks
Extract Urls from Google Sheets
blog.bettersheets.co/extract-...
⚙️Automate Your Sheets:
Spreadsheet Automation 101, get started making your sheets work for you, while you sleep
Start Automating: bettersheets.co/courses/sprea...
Learn to Code in Sheets - A quick course to get you started on Apps Script. Coding in sheets makes automating your sheets so much easier!
Learn here: www.udemy.com/course/learn-to...
📺Step-by-Step Tutorials
Find EVERYTHING you need to make your spreadsheets better on my website BetterSheets.co
Disclaimer: Some of these links go to one of my websites and some are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you.

[@pierreg2780]

This will be perfect for my loot table/encounter table for Dnd! Thank!

[@BetterSheets]

Amazing!

[@mooripo]

That's beautiful ! Thnk you

[@BetterSheets]

Glad you liked it.

[@agoogleuser6937]

Magic!!

[@BetterSheets]

Abracadabera

[@edison.villamor]

Can you put this formula inside an arrayformula? that way we don't have to copy paste all of them until the last row? Or is there any other way to achieve this? Just wanted to do it all in once cell.

[@BetterSheets]

Not that I can tell. Array Formula doesn't work on filter for this.