---
title: "How to link cells, tabs and sheets in Google Sheets"
canonical: "https://www.owox.com/blog/articles/linking-data-across-multiple-google-sheets"
updated: "2026-10-11"
---

# How to link cells, tabs and spreadsheets in Google Sheets

Reference a cell on another tab with ='Sheet2'!A1, pull matching values with VLOOKUP, combine tabs with QUERY and FILTER, connect two spreadsheet files with IMPORTRANGE, and add clickable links between tabs. With examples and fixes for the errors that linking produces.

[Google Sheets Tips](/blog/topics/google-sheets-tips) · Updated October 2, 2026 · [Vadym Kramarenko](/team/vadym-kramarenko) · 11 min read

![How to link cells, tabs and spreadsheets in Google Sheets](https://cdn.owox.ai/www/webflow/69eb90b95e7ed3e65ccc5509_EFFICIENT-DATA-LINKING-ACROSS-MULTIPLE-GOOGLE.png/public)

To link a cell from another tab in Google Sheets, type an equals sign, the tab name, an exclamation mark and the cell: **\=‘Sheet2’!A1**. The cell then shows whatever is in A1 of Sheet2 and follows it when it changes. To link data from a different spreadsheet file, use **IMPORTRANGE**. To make a clickable link that jumps to another tab, use **Insert → Link**.

| You want to | Use |
| --- | --- |
| Show a cell or range from another tab | `='Sheet2'!A1` or `='Sheet2'!A1:C10` |
| Pull the matching value for an ID from another tab | VLOOKUP |
| Combine or filter rows from other tabs | QUERY, FILTER, curly braces |
| Bring in data from another spreadsheet file | IMPORTRANGE |
| Jump to another tab or range with a click | Insert → Link |

The examples below use two tabs of one spreadsheet.

**Inventory Management** lists the products in stock: product ID, name, category, supplier, units in stock, reorder level and unit price.

![The Inventory Management sheet, listing the products available in stock.](https://cdn.owox.ai/www/webflow/6788431f1f6d5ffe19ff1d0c_55977.png/public)

**Sales Orders** lists the orders: order ID, customer name, product ID, quantity ordered, order date, shipment date and total order value.

![The Sales Orders sheet, listing each order with its product and quantity.](https://cdn.owox.ai/www/webflow/6788431f82aee2139a76f8c3_55979.png/public)

## Reference a cell or a range on another tab

### One cell

> `='SheetName'!CellReference`

The single quotes are required when the tab name contains a space, and harmless when it does not. To show cell B3 of the Inventory Management tab on another tab:

> `='Inventory Management'!B3`

![Google Sheets with a cell-by-cell reference pulling one value from the Inventory Management sheet.](https://cdn.owox.ai/www/webflow/6788431fce558fedff770df3_55983.png/public)

You do not have to type the reference. Type **\=**, click the other tab, click the cell and press Enter; Google Sheets writes the reference for you.

### A range

The same syntax takes a range. This shows the customer names from the Sales Orders tab:

> `='Sales Orders'!C2:C11`

![Google Sheets with a range reference pulling a column of values from the Sales Orders sheet.](https://cdn.owox.ai/www/webflow/6788431f5874f58fa9b760fb_55985.png/public)

The values fill the cells below the formula, so those cells must be empty.

### A range inside a function

A reference to another tab works anywhere a normal reference does. To total the quantities ordered:

> `=SUM('Sales Orders'!E2:E11)`

![Google Sheets with SUM totalling a range on the Sales Orders sheet from another sheet.](https://cdn.owox.ai/www/webflow/67884320c34f4150602ee51a_55987.png/public)

## Look up matching values from another tab

A plain reference copies cells by position. When you need the value that belongs to a particular ID, use a lookup.

### VLOOKUP

> `=VLOOKUP(search_key, range, index, [is_sorted])`

*   **search\_key:** the value to look for.
*   **range:** the table to search. The key is looked up in its first column.
*   **index:** the number of the column to return, counting from the first column of the range.
*   **is\_sorted (optional):** FALSE (or 0) for an exact match, which is what you want for IDs.

To get the unit price of a product by its ID from the Inventory Management tab:

> `=VLOOKUP('Inventory Management'!B3,'Inventory Management'!$B$3:$H$12,7,0)`

![Google Sheets with VLOOKUP pulling a value from the seventh column of the Inventory Management table.](https://cdn.owox.ai/www/webflow/6788431f9db9d6182ea30c2f_55992.png/public)

The formula looks up the product ID in the first column of B3:H12 and returns the value from the **seventh column**, the unit price. The dollar signs keep the table fixed when the formula is copied down.

**💡** _More on lookups in our_ [_guide to VLOOKUP in Google Sheets_](/blog/articles/vlookup-in-google-sheets)_._

[![Everything about VLOOKUP in Google Sheets](https://cdn.owox.ai/www/webflow/679fdb191255e16c60379eea_679fdaf4dd31b1670c3e684d_-D0-97-D0-BD-D1-96-D0-BC-D0-BE-D0-BA-20-D0-B5-D0-BA-D1-80-D0-B0-D0-BD-D0-B0-202025-02-02-20-D0-BE-2022.51.35.png/public)](/blog/articles/vlookup-in-google-sheets)

### HLOOKUP

HLOOKUP does the same for data laid out in rows: it searches the first row of the range and returns a value from the row you name.

![Google Sheets with a horizontal dataset with product IDs across the first row and values beneath.](https://cdn.owox.ai/www/webflow/6788431fdae6777e61d044f3_55998.png/public)

To find the value for product P004 in the third row of this table:

> `=HLOOKUP("P004", 'Horizontal Dataset'!B2:G4, 3)`

![Google Sheets with HLOOKUP finding product P004 in a horizontal dataset and returning the third row.](https://cdn.owox.ai/www/webflow/67884320fd0f744ac2648d7d_56000.png/public)

### INDIRECT: a reference built from text

> `=INDIRECT(cell_reference_as_string, [is_A1_notation])`

INDIRECT turns a text string into a reference. That lets you build the tab name or the range from the contents of other cells, for example to switch between monthly tabs with a drop-down.

> `=INDIRECT("'Inventory Management'!C4:C10")`

![Google Sheets with INDIRECT pulling a range from the Inventory Management sheet by its name as text.](https://cdn.owox.ai/www/webflow/67884320654a7c5a5bff88d6_56004.png/public)

The result is the product names in C4:C10. With the names in place, a VLOOKUP returns the reorder level of each product:

> `=VLOOKUP(B3,'Inventory Management'!$C$2:$H$12,5,0)`

![Google Sheets with VLOOKUP referencing the Inventory Management sheet through a lookup range.](https://cdn.owox.ai/www/webflow/6788432053028fa5b1284bb3_56008.png/public)

One caution: a reference inside INDIRECT is text. If the tab is renamed, a normal reference updates itself and an INDIRECT string does not.

## The Turning Point

OWOX Data Marts

See your first report built in real time. _15 minutes._

1.  Connect your data warehouse
2.  Pick your metrics
3.  Get a live Google Sheets report

In the time it takes to write a ticket. Then imagine never writing that ticket again.

[Book a Demo](/book-a-call)

We'll use your actual use case

## Combine and filter data from other tabs

### Two ranges side by side with QUERY

Curly braces build an array out of several ranges: a **comma** puts them side by side, a **semicolon** stacks them one under the other. [QUERY](/blog/articles/query-function-google-sheets) can then filter the combined array.

> `=QUERY({'Inventory Management'!B2:G11, 'Sales Orders'!B2:G11}, "select * where Col1 <> ''", 1)`

![Google Sheets with QUERY combining the Inventory Management and Sales Orders sheets into one table.](https://cdn.owox.ai/www/webflow/678843209ed651aa692a8ec7_56022.png/public)

*   **{Range1, Range2}:** places the two ranges next to each other. Both must have the same number of rows.
*   **select \* where Col1 <> ‘’:** returns every column, for the rows where the first column is not empty. Inside an array, columns are called Col1, Col2 and so on.
*   **1:** the first row is a header.

[![Exploring Google Sheets QUERY Function: Tips and Tricks for Efficient Data Management](https://cdn.owox.ai/www/webflow/679fd87bf9c975a1e47280a4_679fd7d0e870a95c8030ba45_-D0-97-D0-BD-D1-96-D0-BC-D0-BE-D0-BA-20-D0-B5-D0-BA-D1-80-D0-B0-D0-BD-D0-B0-202025-02-02-20-D0-BE-2022.38.12.png/public)](/blog/articles/query-function-google-sheets)

### Rows that meet a condition with FILTER

The [FILTER function](/blog/articles/google-sheets-filter-function) returns the rows of a range that pass a test:

> `=FILTER(range, condition1, [condition2, …])`

To list the products with fewer than 50 units in stock:

> `=FILTER('Inventory Management'!B3:G11, 'Inventory Management'!F3:F11 < 50)`

![Google Sheets with FILTER returning inventory rows where the quantity is under 50.](https://cdn.owox.ai/www/webflow/678843205d32042cfe6429c1_56028.png/public)

### Several tabs stacked into one column

Semicolons stack the results. This puts a heading, the product IDs from one tab and the order IDs from the other into a single column:

```
={
"Pulling Data from Multiple Sheets into One Column";
 FILTER('Inventory Management'!B2:B, LEN('Inventory Management'!B2:B) > 0); FILTER('Sales Orders'!B2:B, LEN('Sales Orders'!B2:B) > 0)
}
```

![Google Sheets with FILTER results from several sheets stacked into one column with a heading.](https://cdn.owox.ai/www/webflow/6788432292d6f486bb9e7288_56032.png/public)

The LEN test leaves out the empty cells at the bottom of each open-ended range.

### Whole columns or rows

To mirror entire columns of another tab, reference the columns without row numbers:

> `={'Inventory Management'!B:D}`

![Google Sheets with curly braces pulling columns B to D of the Inventory Management sheet into another tab.](https://cdn.owox.ai/www/webflow/67884321727d5be15fe7d074_56042.png/public)

And for entire rows, reference the row numbers:

> `={'Inventory Management'!2:5}`

![Google Sheets with curly braces pulling rows 2 to 5 of the Inventory Management sheet into another tab.](https://cdn.owox.ai/www/webflow/67884320c8eceb442813f9f2_56048.png/public)

## Jump to another tab with a clickable link

A link does not copy data. It takes the reader to a place in the spreadsheet, which is useful for a table of contents or a “see details” cell.

1.  Select the cell that should hold the link.
2.  Go to **Insert → Link** (Ctrl + K, or Cmd + K on a Mac).
3.  Choose **Sheets and named ranges**.
4.  Pick a tab, or choose **Select a range of cells to link** and enter the range, for example ‘Inventory Management’!C2:C12.
5.  Click **Apply**.

![A cell holding a link to the range ‘Inventory Management’!C2:C12, with the link preview open.](https://cdn.owox.ai/www/webflow/67884320fcf6fa308870e16f_56034.png/public)

### Link to a named range

A named range gives the destination a readable name that survives when rows are inserted above it.

1.  Select the range, here C2:C12 on the Inventory Management tab, and name it “Products” under **Data → Named ranges**.
2.  In the cell that should hold the link, go to **Insert → Link → Sheets and named ranges** and choose **Products**.

![A cell holding a link to the named range Products, with the link preview open.](https://cdn.owox.ai/www/webflow/6788432111c6b0e43f38e406_56038.png/public)

## Link two spreadsheets with IMPORTRANGE

References with a tab name only work inside one file. To bring in data from another spreadsheet, use [IMPORTRANGE](/blog/articles/importrange-google-sheets):

> `=IMPORTRANGE("spreadsheet_url", "range_string")`

*   **spreadsheet\_url:** the URL of the source spreadsheet, in quotes.
*   **range\_string:** the tab name and range to import, in quotes, for example “Sales2024!B2:D100”.

The first time a spreadsheet imports from another one, the formula returns #REF! with the message that the sheets need to be connected. Click the cell and choose **Allow access**. You need at least view access to the source file.

Several imports can be stacked with curly braces and a semicolon. This puts two tabs of another spreadsheet under each other:

```
={IMPORTRANGE("https://docs.google.com/spreadsheets/d/16puodzCJMaUJuTjoYa-nDZ38N3sIWYMlt-OKznrkvGs/edit", "Sales2024!B2:D100");
IMPORTRANGE("https://docs.google.com/spreadsheets/d/16puodzCJMaUJuTjoYa-nDZ38N3sIWYMlt-OKznrkvGs/edit", "AnnualSales!B2:D100")}
```

![The combined data returned when a range is pulled from a different spreadsheet.](https://cdn.owox.ai/www/webflow/67884321271aa5d00f99d3f3_56016.png/public)

[![The Ultimate Guide to Using IMPORTRANGE in Google Sheets](https://cdn.owox.ai/www/webflow/679ffc99ee6bcf381453e79a_679ffbe9e26375704fd384d1_-D0-97-D0-BD-D1-96-D0-BC-D0-BE-D0-BA-20-D0-B5-D0-BA-D1-80-D0-B0-D0-BD-D0-B0-202025-02-03-20-D0-BE-2001.12.08.png/public)](/blog/articles/importrange-google-sheets)

## Problems when linking sheets, and how to fix them

### The import asks for access

❌ **Error:** IMPORTRANGE returns #REF!, or collaborators see errors where you see data.

✅ **Solution:** Click the cell and allow access. Then check the sharing settings of the source file with the **Share** button: everyone who needs the linked data should have at least view access to the source.

![The Share button in the top right of Google Sheets, used to update access permissions.](https://cdn.owox.ai/www/webflow/67884320b578ff949902d6b9_56052.png/public)

### Quotes are missing

❌ **Error:** The formula is rejected because the URL or the range is not in quotes.

> `=IMPORTRANGE(https://docs.google.com/spreadsheets/d/16puodzCJMaUJuTjoYa-nDZ38N3sIWYMlt-OKznrkvGs/edit, AnnualSales!A1:B10)`

![Google Sheets with an IMPORTRANGE formula that fails because its syntax is wrong.](https://cdn.owox.ai/www/webflow/67884320f5650b084ab2ed49_56056.png/public)

✅ **Solution:** Put both arguments of IMPORTRANGE in double quotes. In references inside the same file, put the tab name in single quotes when it contains a space.

### The tab or the range does not exist

❌ **Error:** The formula returns #REF! because the tab named in it was renamed or deleted, or the range string is not valid.

> `=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1ND3202nplI_2hFcgb-s4OUyDKkYGDQDGZ_rmEDgsxDg/edit", "DataSheet1!1:1")`

![Google Sheets with an IMPORTRANGE formula returning an error because the tab or range it names cannot be found.](https://cdn.owox.ai/www/webflow/67884320d22c536c6b65cf84_56060.png/public)

✅ **Solution:** Check the tab name and the range in the formula against the source. Direct references such as ‘Sales Orders’!A1 follow a renamed tab automatically. The text inside IMPORTRANGE and INDIRECT does not, and has to be corrected by hand.

### Circular dependency

❌ **Error:** A formula refers to its own cell, directly or through other cells, and Google Sheets reports “Circular dependency detected”.

> `=SUM(A1:A10) + B1`

![Google Sheets with a circular reference error from a SUM that includes the cell holding the formula.](https://cdn.owox.ai/www/webflow/678843205c43ccbab03856ef_56062.png/public)

✅ **Solution:** Move the formula out of the range it refers to, or split the calculation across a helper cell so that no cell depends on itself.

### The spreadsheet gets slow

❌ **Error:** A file with many cross-tab formulas and imports becomes slow to open and recalculate.

✅ **Solution:** Reference only the range you need instead of whole columns, delete unused rows and columns, and replace chains of IMPORTRANGE between many files with one source. A spreadsheet can hold up to 10 million cells; performance drops long before that.

## Related Google Sheets functions

Functions that are often used when linking data, each with its own guide:

*   [XLOOKUP](/blog/articles/key-differences-of-xlookup-vs-vlookup): A more flexible lookup that can return values from any direction.
*   [IMPORTXML](/blog/articles/importxml-function-google-sheets), [IMPORTHTML](/blog/articles/importhtml-function-google-sheets) and [IMPORTFEED](/blog/articles/importfeed-function-google-sheets): Import data from web pages and feeds.
*   [UNIQUE](/blog/articles/unique-function-google-sheets): Returns the distinct values of a range.
*   [Pivot tables](/blog/articles/pivot-tables-google-sheets): Summarize data from a range by categories.
*   [MATCH](/blog/articles/google-sheets-match-function): Returns the relative position of an item in a range.
*   [ARRAYFORMULA](/blog/articles/array-formulas-google-sheets): Applies a formula to a whole column or range at once.
*   [IF](/blog/articles/if-function-google-sheets): Returns one value when a condition is true and another when it is false.
*   [QUERY vs VLOOKUP](/blog/articles/query-vs-vlookup-google-sheets): Compares the two functions and shows when each is the better choice.
*   [Currency conversion with GOOGLEFINANCE](/blog/articles/googlefinance-currency-conversion-google-sheets): Pulls current and historical exchange rates to convert amounts between currencies.

## When the source is not a spreadsheet at all

Everything above links one sheet to another sheet. That works until the data everyone depends on lives somewhere else: in a data warehouse, an ad platform or a CRM. Then the chain usually starts with someone exporting a file and pasting it into a “raw data” tab, and every IMPORTRANGE downstream faithfully copies whatever was pasted, however old it is.

The [OWOX Data Marts extension for Google Sheets](https://workspace.google.com/marketplace/app/owox_data_marts/94902851409) replaces that first, manual link. A data analyst publishes a data mart (a table or an SQL query in your data warehouse) and makes it available for reports. You open the extension from the Extensions menu of the spreadsheet, pick the data mart, tick the columns you want and run it. The rows land in a tab, and your references, lookups and imports work on top of them.

![Google Sheets with the OWOX Data Marts extension open beside an ad spend table: the Unified Ad Spend data mart, nine of fourteen columns ticked and a Save & Run button – the rows in the sheet come from a governed data mart, not a pasted export](https://cdn.owox.ai/www/content-marketing-article/linking-data-across-multiple-google-sheets/screens/1.png/public)

What changes for the person who maintains the sheet:

*   **Refresh replaces re-export.** _Refresh current report_ re-runs the same pull, and a scheduled refresh keeps the tab current without anyone touching it.
*   **The source is written on the sheet.** The header cell of an imported tab carries a note with the data mart it came from, the time of the import and a link to the report.
*   **No SQL and no warehouse access needed.** The analyst decides which data marts and columns are available. You choose from that list.

The extension does not write or change the analyst’s SQL, and it does not replace the techniques in this guide: tabs still reference each other the same way. It makes the first tab in the chain trustworthy. When that tab needs columns from several warehouse tables, see [joined Data Marts in Google Sheets](/blog/articles/joinable-data-marts-google-sheets). The extension comes with the OWOX Cloud plans of [OWOX Data Marts](https://www.owox.com/app-signup); [spreadsheet reporting](/features/spreadsheet-reporting) describes both ways data reaches a sheet.

## Your New Normal

Turn your data into decisions.

Governed data marts give you the clean foundation ML needs to actually work.

*   No AI hallucinations
*   Analyst-governed definitions
*   Every number traces to SQL

[Get started free](https://www.owox.com/app-signup)

## FAQ

## Frequently Asked Questions

What best practices should I follow while linking data across sheets?

When linking data across sheets in Google Sheets, follow these best practices to ensure data integrity and efficiency. Use named ranges for explicit and manageable references, employ array formulas for dynamic calculations, and consistently update cell references after sheet modifications. Leverage functions like IMPORTRANGE and QUERY to streamline data integration and real-time synchronization. Document any changes to maintain transparency and consistency across all linked data sources.

How can I use the QUERY function to import conditional data?

To import specific data based on conditions, use the QUERY function like this:=QUERY(IMPORTRANGE("spreadsheet\_url", "range"), "SELECT columns WHERE condition")Here's a breakdown of the elements used in the formula:IMPORTRANGE: This function pulls data from another Google Sheet.spreadsheet\_url: The web link to the Google Sheet you want to pull data from.range: The specific range of cells you want to import (e.g., "Sheet1!A1").QUERY: This function filters and organizes the imported data.SELECT columns: Specifies which columns to include in the results.WHERE condition: Sets the condition to filter the data (e.g., "WHERE D > 1000").

What should I do if I encounter REF errors due to invalid references?

If you encounter #REF errors in Google Sheets due to invalid references, verify that the referenced cells or ranges exist and have not been deleted or moved. Update or correct the affected formulas to point to valid references. Ensure that any referenced sheets are correctly named and accessible.Regularly auditing your sheets for #REF errors helps maintain data accuracy and prevents disruptions in data analysis workflows. Properly handling these errors is crucial for ensuring reliable and consistent data operations.

How can I import data using the IMPORTRANGE function from another sheet?

To import data from another sheet in Google Sheets, use the IMPORTRANGE function. The syntax is =IMPORTRANGE(spreadsheet\_url, range\_string), where spreadsheet\_url is the link to the source sheet, and range\_string specifies the data range.For example, =[IMPORTRANGE](https://docs.google.com/spreadsheets/d/abc123/edit\) will import the specified range. This function allows real-time data integration across sheets.

What are the benefits of linking data across multiple Google Sheets?

Linking data across multiple Google Sheets provides a lot of advantages, such as enhanced data consistency and accuracy. It allows for integrating disparate data sources, creating a centralized repository for comprehensive data analysis. This approach supports real-time updates, ensuring that any changes in source sheets are reflected across all linked documents. It also improves collaborative workflows by enabling different teams to access and update shared data seamlessly, optimizing operational efficiency.

How do I link data within the same Google Sheets document?

Use a reference with the tab name: ='Sheet2'!A1 shows cell A1 of the tab Sheet2, and ='Sheet2'!A1:C10 shows a range. The single quotes are needed when the tab name contains a space. You can also type =, click the other tab, click the cell and press Enter.

## Who wrote this

![Vadym Kramarenko](https://cdn.owox.ai/www/webflow/6798e703afdf787334941cde_Vadym-Kramarenko.png/public)

[Vadym Kramarenko](/team/vadym-kramarenko) · Growth Marketing Manager

Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks.

[LinkedIn](https://www.linkedin.com/in/vadim-kramarenko/) · [All articles](/team/vadym-kramarenko)

[Google Sheets Tips](/blog/topics/google-sheets-tips)

## Related articles

[Google Sheets Tips · Pivot tables in Google Sheets: how to create and use them · October 2, 2026](/blog/articles/pivot-tables-google-sheets)

[Google Sheets Tips · QUERY with CONCATENATE in Google Sheets: join two columns · October 2, 2026](/blog/articles/query-with-concatenate-google-sheets)

[Google Sheets Tips · IF with VLOOKUP in Google Sheets: formulas and examples · October 2, 2026](/blog/articles/how-to-use-vlookup-with-if-statement-in-google-sheets)

[See all articles →](/blog/articles)

## Book a call

You are booked. The invitation is on its way to , with the calendar invite and the meeting link.

[Reschedule](#)

[Cancel](#)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Google Sheets Tips](https://www.owox.com/blog/topics/google-sheets-tips) — /blog/topics/google-sheets-tips.md
- [Vadym Kramarenko](https://www.owox.com/team/vadym-kramarenko) — /team/vadym-kramarenko.md
- [guide to VLOOKUP in Google Sheets](https://www.owox.com/blog/articles/vlookup-in-google-sheets) — /blog/articles/vlookup-in-google-sheets.md
- [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.md
- [QUERY](https://www.owox.com/blog/articles/query-function-google-sheets) — /blog/articles/query-function-google-sheets.md
- [FILTER function](https://www.owox.com/blog/articles/google-sheets-filter-function) — /blog/articles/google-sheets-filter-function.md
- [IMPORTRANGE](https://www.owox.com/blog/articles/importrange-google-sheets) — /blog/articles/importrange-google-sheets.md
- [XLOOKUP](https://www.owox.com/blog/articles/key-differences-of-xlookup-vs-vlookup) — /blog/articles/key-differences-of-xlookup-vs-vlookup.md
- [IMPORTXML](https://www.owox.com/blog/articles/importxml-function-google-sheets) — /blog/articles/importxml-function-google-sheets.md
- [IMPORTHTML](https://www.owox.com/blog/articles/importhtml-function-google-sheets) — /blog/articles/importhtml-function-google-sheets.md
- [IMPORTFEED](https://www.owox.com/blog/articles/importfeed-function-google-sheets) — /blog/articles/importfeed-function-google-sheets.md
- [UNIQUE](https://www.owox.com/blog/articles/unique-function-google-sheets) — /blog/articles/unique-function-google-sheets.md
- [Pivot tables](https://www.owox.com/blog/articles/pivot-tables-google-sheets) — /blog/articles/pivot-tables-google-sheets.md
- [MATCH](https://www.owox.com/blog/articles/google-sheets-match-function) — /blog/articles/google-sheets-match-function.md
- [ARRAYFORMULA](https://www.owox.com/blog/articles/array-formulas-google-sheets) — /blog/articles/array-formulas-google-sheets.md
- [IF](https://www.owox.com/blog/articles/if-function-google-sheets) — /blog/articles/if-function-google-sheets.md
- [QUERY vs VLOOKUP](https://www.owox.com/blog/articles/query-vs-vlookup-google-sheets) — /blog/articles/query-vs-vlookup-google-sheets.md
- [Currency conversion with GOOGLEFINANCE](https://www.owox.com/blog/articles/googlefinance-currency-conversion-google-sheets) — /blog/articles/googlefinance-currency-conversion-google-sheets.md
- [joined Data Marts in Google Sheets](https://www.owox.com/blog/articles/joinable-data-marts-google-sheets) — /blog/articles/joinable-data-marts-google-sheets.md
- [OWOX Data Marts](https://www.owox.com/app-signup)
- [spreadsheet reporting](https://www.owox.com/features/spreadsheet-reporting) — /features/spreadsheet-reporting.md
- [Google Sheets Tips · QUERY with CONCATENATE in Google Sheets: join two columns · October 2, 2026](https://www.owox.com/blog/articles/query-with-concatenate-google-sheets) — /blog/articles/query-with-concatenate-google-sheets.md
- [Google Sheets Tips · IF with VLOOKUP in Google Sheets: formulas and examples · October 2, 2026](https://www.owox.com/blog/articles/how-to-use-vlookup-with-if-statement-in-google-sheets) — /blog/articles/how-to-use-vlookup-with-if-statement-in-google-sheets.md
- [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md