Pulling Data from another sheet in Google Sheets is a very simple process. This tutorial will walk through the steps to pull data from other sheets in Google Sheets
Setting up the Data
For this Example, we will use two Sheets. Sheet 1- cell A2 will be the formula cell. Sheet 2 will be the reference Sheet where we will pull the data from. In Column A of Sheet 2, enter some test data to reference in our formula
Figure 1 – Sheets 1 an 2 Data Setup
Applying the formula Single Cell
Now that we have our data setup, the next step is to enter our formula in cell A1 of Sheet 1
- In cell A1 of Sheet 1, enter this formula =’Sheet2’!A1
Figure 2 – Applying the Formula in a Single Cell
We can see in this example that by entering the referencing Sheets name in this format ‘Sheet Name!’, the formula pulled the data associated with Sheet 2 into Sheet 1.
Applying the formula to a Range
Now that we know how to apply the formula to a single cell, we can use the same concept to apply to a range of data. Not only will we apply this formula into a range of data, but we will illustrate how we can nest this formula inside others in order to reference other sheets in any formula
- In Column B of Sheet 2, enter some numeric data
- In cell B7 of Sheet 2, enter this formula =sum(B1:B6)
- In cell A3 of Sheet 1, enter this formula = sum(‘Sheet 2’!B1:B6)
Figure 3 – Applying the Formula to a Range
We can see in this example the formula in Sheet 1, cell A2 sums the data in range B1:B6 of Sheet 2 to match the sum result in Sheet 2, cell B7. This same concept can be applied for any Excel formula
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.
Are you still looking for help with the VLOOKUP function? View our comprehensive round-up of VLOOKUP function tutorials here.