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 — https://twitter.com/rosenz and https://twitter.com/macmost 🐦
▶︎ Facebook — https://facebook.com/macmost 👍

SUPPORT MACMOST AT PATREON
▶︎ https://macmost.com/patreon ❤️

#macmost #numbers #numberstutorials

Youtube