If you want to pull data into your sheet from other tabs, this video will walk you through how to do that. Sheet used in the video: 🕒 Timestamps: 0:00 Introduction 0:58 Overview and terminology 1:48 Create the reference 3:05 Copy it to other cells 5:54 Inside of longer formula 6:44 Copy to another column 8:40 Pivot table from another worksheet 9:24 Pull in an entire table 11:05 Next video (automate the process) Learn more from Prolific Oaktree: 🌳 Next Video - Pivot Tables in Sheets vs. Excel - 🌳 Related Playlist - Google Apps | Full Tutorials - #googlesheets #link #reference