Tech

How to Use Google Sheets to Reference Data From Another Sheet

Easily import data from other tabs and spreadsheets

what you need to know

  • Place the cursor in the cell where you want to place the data.
  • Extract data from another sheet: Type = and select the cell in the source sheet to import this data to the original sheet.
  • Extract from another file: Type =IMPORTRANGE(“URL”,”Sheet1!C2″), replace urls with the link to the other file, followed by the cell reference.

This article explains how to reference data from another sheet in Google Sheets.

Related Articles

How to extract cell data from another sheet

The most common reason people want to pull data from another sheet into Google Sheets is when those other tables are lookup tables.

For example, one sheet might contain all the products you sell with their UPC codes and unit prices, while another sheet might contain a record of your sales. To calculate the total sale, you will need to extract the price data from the list. That is how:

On the original sheet where you want to extract data, place the cursor in the cell where you want the data to go.

Type = (the equals sign) in the cell. Select the second sheet, then the cell that contains the data you want to import to the original sheet.

Selecting the sheet where the data comes from

Hurry Get in to end. This will bring the data from the cell you selected to the first spreadsheet.

Data transferred to the original sheet

The final formula in this case is =Sheet2!C2. ‘Sheet2’ is the name of the sheet where the data comes from. This method is ideal for referencing data from individual cells from a different spreadsheet to an original spreadsheet.

Extract cell data from another spreadsheet file

You can also reference data from a different spreadsheet file with the IMPORT RANGE formula.

Before you can use the IMPORTRANGE formula, you’ll need the URL link to the Google Sheets file where you want to reference the data. Highlight and copy the URL link at the end of the long code before the last slash (/) in the URL.

Copy spreadsheet link to Google Sheets

In the original sheet where you want to extract the data, place the cursor in the destination cell and type:

=IMPORTRANGE(“URL”

be sure to replace urls in this formula with the URL you want to reference.

Entering spreadsheet_url in the IMPORTRANGE function

Follow the quotes after the URL with a comma (,), then type the name of the sheet and cell whose data you want to get.

In this example, you would enter:

=IMPORTRANGE(“URL”,”Sheet1!C2″).

Again, urls would be a full URL. We’re just keeping it short for example purposes.

Entering cell data in the IMPORTRANGE function

Hurry Get in. You’ll see that the data from the other Sheets spreadsheet file is pulled into this spreadsheet.

Data imported into a Google Sheets spreadsheet

Học Wiki

The #hocwiki website provides basic electronic knowledge about capacitors, resistors, and knowledge of circuits, hoping to bring you the most useful online electronic knowledge.

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Back to top button