How to Call Data from Another Sheet in Excel

Manually retyping or copy-pasting data between Excel sheets is not only tedious but also a recipe for costly mistakes. A much better way is to call the data you need directly from its source, creating a dynamic link that updates automatically. This article walks you through several methods to pull data from another sheet in Excel, starting with a simple click and moving to more powerful lookup functions.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Reference Data Across Sheets?

Working with data across multiple sheets in a single workbook is a fundamental Excel skill. It keeps your data organized, secure, and easy to manage. Instead of cramming all your information onto one giant, overwhelming sheet, you can separate raw data from summaries, dashboards, and calculations.

Here are a few key benefits:

• Better Organization: You can keep a "master" sheet for raw data (like a list of all sales transactions) and a separate, clean "summary" sheet for your reporting dashboard.
• Reduced Errors: By linking directly to the source cell, you eliminate the risk of typos or copy-paste errors that happen during manual data transfer.
• Automatic Updates: When a value changes on your source data sheet, any cell that references it on another sheet updates instantly. Your reports are always current without you having to do anything.
• Single Source of Truth: Everyone working in the workbook knows that the raw data sheet is the ultimate source. This avoids confusion and version control issues.

Method 1: The Simple Cell Reference

The most straightforward way to call data from another sheet is by creating a direct link to a specific cell. This is perfect for when you know exactly which cell contains the data you need, like a "Total Sales" figure in a calculations sheet that you want to display on a summary page.

This method points one cell directly to another. Here’s how to do it:

1. Navigate to the sheet where you want the data to appear (your destination sheet).
2. Click on the cell where you want to display the data and type the equals sign (=). Do not press Enter yet.
3. Click on the tab of the sheet containing the data you want to reference (your source sheet).
4. Click on the specific cell in the source sheet that holds the data.
5. Press Enter. Excel will automatically take you back to your destination sheet, and the cell will now display the data from the source cell.

If you look in the formula bar, you'll see a reference that looks like this:

=SheetName!CellAddress

For example, if you wanted to pull the contents of cell F5 from a sheet named "SalesData", the formula would be:

=SalesData!F5

A quick tip: If your sheet name contains spaces (e.g., "Sales Data"), Excel will automatically wrap the name in single quotes. The formula would look like this:

='Sales Data'!F5

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 2: Using Named Ranges for Readability

While direct cell references are easy, formulas like ='Q1 Sales Figures'!$F$37 can quickly become hard to read and understand. A much cleaner approach is to use Named Ranges. A Named Range allows you to assign a simple, memorable name (like "Q1_TotalRevenue") to a single cell or a range of cells.

This makes your formulas more intuitive and less prone to breaking if you accidentally move the source data.

How to Create a Named Range

1. Go to your source sheet and select the cell or range of cells you want to name.
2. Navigate to the Formulas tab in the Excel ribbon.
3. Click on Define Name.
4. In the "New Name" dialog box, enter a descriptive name for your range in the "Name" field. Note: Names cannot contain spaces. Use an underscore (_) or capitalize words instead (e.g., "TotalRevenue" or "Total_Revenue").
5. Verify that the "Refers to" field points to the correct cells and click OK.

How to Use the Named Range on Another Sheet

Now, pulling that data is incredibly simple.

1. Go to your destination sheet.
2. In your desired cell, type = followed by the name you just created (e.g., =Q1_TotalRevenue).
3. Press Enter.

The formula is now easy to understand at a glance, and if you ever need to reference this value again, you just have to remember the name, not a complicated cell and sheet address.

Method 3: VLOOKUP for Finding Specific Data

What if you don't want a static cell? What if you need to find a specific piece of information in a large table? That's where VLOOKUP (Vertical Lookup) comes in. It's one of Excel's most well-known functions and is perfect for searching for a value in the first column of a table and returning a corresponding value from another column in the same row.

Think of it as looking up someone's name in a directory to find out their department.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

The VLOOKUP Syntax

The formula structure for VLOOKUP is:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• lookup_value: The value you are searching for (e.g., a specific product ID).
• table_array: The range of data where you will search for the lookup value. This range must be on your source data sheet, and the column containing the lookup value must be the first column in this range.
• col_index_num: The number of the column within your defined table_array that contains the result you want to return. For example, if you want the value from the third column of the table, this number would be 3.
• range_lookup: This is an optional argument that determines if you want an exact or approximate match. You should almost always use FALSE for an exact match. Using TRUE or leaving it blank can return unexpected results unless your data is sorted in a specific way.

Step-by-Step VLOOKUP Example

Imagine you have two sheets:

• "Products": A list of products with Product ID in column A, Product Name in column B, and Price in column C.
• "Invoice": A sheet where you can type a Product ID in column A, and you want the Product Name and Price to populate automatically.

To pull the product name onto the "Invoice" sheet:

1. In the "Invoice" sheet, click on the cell where you want the product name to appear (let's say it's cell B2).
2. Type the following formula:

=VLOOKUP(A2, Products!$A$2:$C$100, 2, FALSE)

Let's break that down:

• A2 is the lookup_value: it's the cell on our Invoice sheet where we will type the Product ID we're looking for.
• Products!$A$2:$C$100 is the table_array: it's the table of data on the "Products" sheet. We use $ signs (absolute references) so the table range doesn't shift if we drag the formula down.
• 2 is the col_index_num: we want to return the product name, which is in the second column of our table.
• FALSE tells VLOOKUP to find an exact match for the Product ID.

Now, when you type a valid Product ID in cell A2, the corresponding product name will instantly appear in B2. To get the price, you'd use a nearly identical formula in C2, just changing the column index number to 3.

Method 4: INDEX and MATCH - A More Flexible Approach

While VLOOKUP is powerful, it has a significant limitation: it can only look up values in the leftmost column of a table. If you need to search for a value in a different column, VLOOKUP won't work. This is where the combination of the INDEX and MATCH functions shines.

Combining these two functions is widely considered a superior and more flexible alternative to VLOOKUP.

How INDEX and MATCH Work Together

1. MATCH finds the location: The MATCH function searches for a lookup value within a column and tells you its numerical position (i.e., the row number).
2. INDEX retrieves the value: The INDEX function then takes that row number and returns the value from a corresponding cell in a different column.

The INDEX and MATCH Syntax

The formula structure looks like this:

=INDEX(return_column, MATCH(lookup_value, lookup_column, 0))

• return_column: The entire column on your source sheet that contains the data you want to retrieve.
• lookup_value: The value you are searching for (just like in VLOOKUP).
• lookup_column: The entire column on your source sheet that you want MATCH to search through.
• 0: This tells MATCH to find an exact match.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step INDEX and MATCH Example

Let's use our "Products" and "Invoice" sheets again. This time, imagine you want to type a Product Name on the invoice and have Excel look up its corresponding Product ID. VLOOKUP can't do this because Product Name is not the first column. But INDEX and MATCH can handle it easily.

To pull the Product ID using the Product Name:

1. On the "Invoice" sheet, type a product name in cell B2.
2. In cell A2 (where you want the Product ID), enter this formula:

=INDEX(Products!$A$2:$A$100, MATCH(B2, Products!$B$2:$B$100, 0))

• Products!$A$2:$A$100 is the column we want to get a value from (the Product IDs).
• MATCH(B2, Products!$B$2:$B$100, 0) searches for the value in B2 (the Product Name) within the product name column on the "Products" sheet (B2:B100) and finds its row position.

Final Thoughts

Mastering how to call data from other sheets transforms Excel from a simple grid into a powerful tool for dynamic reporting. Whether you're using simple cell references for key summary figures or leveraging INDEX and MATCH to build complex dashboards, these techniques will help you maintain organized, error-free, and automatically updated workbooks.

Of course, connecting data between sheets is only half the battle. The truly repetitive work often involves getting data into Excel in the first place - logging into Google Analytics, Facebook Ads, Shopify, and Salesforce, exporting CSVs, and cleaning them up every week. This is exactly why we built Graphed. We automate the connection to all your marketing and sales platforms, so your data is always unified and up-to-date. Instead of writing complex formulas by hand, you can just ask a question like, "Show me last month's ad spend versus Shopify revenue by campaign," and get an interactive dashboard instantly.