Excel 3D Reference - easily reference data on another worksheet

Posted on:  05/16/2023
Excel 3D Reference - easily reference data on another worksheet

A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination.

Excel 3D reference

Excel 3D reference

You can use multiple functions when creating a 3D reference. Functions such as Sum, Average, Count, Counta, Max, and Min all work with a 3D reference. 

Examples of 3D references

  1. In cell R2 we can use a 3D reference for =B2. Changes in B2 will reflect in cell R2l.
  2. =Monday!B2 reference the Monday worksheet. Changes in cell B2 on the Monday worksheet will update when the source updates.
  3. =Sum(East:West!B2) changes in the worksheets that start with East and go to West for cell B2 will reflect. We could have multiple worksheets between the East and West worksheets. 

YouTube Video

Video of 3D references using multiple worksheets

 

Online Microsoft Teams Training with Chris Menard

50% off coupon

Just some of the topics covered

  1. Navigation Teams
  2. Using private Chat
  3. Using group Chat
  4. Teams Meetings
    1. Scheduling Meetings
    2. Meeting controls
    3. Roles in a meeting
    4. Sharing resources
    5. PowerPoint in a meeting
    6. Scheduling Team meetings from Outlook
  5. Working with Teams and Channels
    1. Conversations
    2. Files
    3. Wiki and OneNote
  6. Using Outlook and Teams
  7. Using apps in Teams
Lifetime access to Teams Course Beginner to Pro with coupon

Recent Articles

OneNote - SORT PAGES  - New Feature - 2022

OneNote - SORT PAGES - New Feature - 2022

3 AWESOME TIPS when working with OneNote & Outlook

3 AWESOME TIPS when working with OneNote & Outlook

Mastering Loan Amortization: A Comprehensive Guide to Understanding and Comparing Loans

Mastering Loan Amortization: A Comprehensive Guide to Understanding and Comparing Loans

Analyzing 50+ Years of Mortgage Rates in Excel: Insights and Trends

Analyzing 50+ Years of Mortgage Rates in Excel: Insights and Trends

Social Security - Breakeven point in Years using Excel

Social Security - Breakeven point in Years using Excel

Excel - Financial Functions for a House or a Car

Excel - Financial Functions for a House or a Car

Categories