Create Powerful Numbers Spreadsheets With the INDIRECT Function
https://macmost.com/e-1994 The INDIRECT function allows you to look up the value of a cell based on a cell reference. So you can take stings like C2 and find the value of the cell C2. This allows you to construct cells references from other values to create powerful lookups that refer to cells in other tables or even sheets. FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY ▶︎ YouTube — http://macmost.com/j-youtube (And hit the 🔔) ▶︎ Weekly Email Newsletter — https://macmost.com/newsletter ✉️ ▶︎ Twitter — / rosenz and / macmost 🐦 ▶︎ Facebook — / macmost 👍 SUPPORT MACMOST AT PATREON ▶︎ https://macmost.com/patreon ❤️ #macmost #numbers #numberstutorials

▶︎
How To Convert Words and Names To Values in Numbers With IF, SWITCH and LOOKUP

▶︎
20 Useful Tips and Tricks For Mac Numbers

▶︎
Creating a Billing and Invoicing System In Numbers (2025)

▶︎
Get Creative With Numbers Spreadsheets

▶︎
Excel Conditional Formatting in Depth

▶︎
Ex-Google Recruiter Explains Why "Lying" Gets You Hired

▶︎
Why The Russian Accent Terrifies Everyone

▶︎
How To Get Monthly Totals From a Numbers Table

▶︎
REGEX() and SUMIF() - Check for multiple matches in Apple Numbers

▶︎
Want to Master Numbers on Your Mac? Watch this online Presentation!

▶︎
Understanding Sheets and Tables In Mac Numbers

▶︎
Organize Your Apple Numbers Spreadsheet with Tables

▶︎
Android 17 sucks. So I put Linux on a phone.

▶︎
Something is jamming GPS over Europe. Here's what we found

▶︎
An Introduction To Using Formulas In Mac Numbers

▶︎
Mac Numbers Conditional Highlighting and Alternatives

▶︎
SUMIF with INDIRECT Function for Dynamic Sheet and Table References

▶︎
The Only VLOOKUP Guide You’ll Ever Need. (No More Errors)

▶︎
Learn how to Use XLOOKUP in Apple Numbers

▶︎
