---
title: "UNIQUE function in Google Sheets: syntax, examples, errors"
canonical: "https://www.owox.com/blog/articles/unique-function-google-sheets"
updated: "2026-10-05"
---

# UNIQUE function in Google Sheets: syntax, examples and common errors

UNIQUE returns the distinct rows of a range and leaves the source data untouched. This guide covers the syntax, the difference between distinct and exactly-once values, drop-down lists without duplicates, combinations with SORT, FILTER, SUMIF, COUNTA and QUERY, and the errors UNIQUE returns.

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

![UNIQUE function in Google Sheets: syntax, examples and common errors](https://cdn.owox.ai/www/webflow/6a1050bbc3d8a7ac7ab4dc30_THE-UNIQUE-FUNCTION-IN-GOOGLE-SHEETS.png/public)

The UNIQUE function in Google Sheets returns the distinct rows of a range, in the order they first appear. Type **\=UNIQUE(B3:B15)** next to your data and you get every value from B3:B15 once, with the duplicates left out. The source data stays untouched.

This guide covers the syntax, the difference between distinct and exactly-once values, worked examples (several columns, horizontal data, drop-down lists), combinations with SORT, FILTER, SUMIF, COUNTA and QUERY, and the errors UNIQUE returns.

**_Note:_** _Originally published in February 2024. Fully updated in October 2026: repeated sections merged, the error examples corrected, and advice that applied to Excel rather than Google Sheets removed._

## UNIQUE function syntax

> `=UNIQUE(range, [by_column], [exactly_once])`

1.  **range**: the data to filter.
2.  **by\_column (optional)**: whether to compare columns instead of rows. FALSE by default, which compares rows.
3.  **exactly\_once (optional)**: whether to return only the entries that appear exactly once. FALSE by default, which returns every distinct entry.

![Syntax and structure of the UNIQUE function in Google Sheets.](https://cdn.owox.ai/www/webflow/6787254599a1fe79ab7a24db_54096.png/public)

Three things to know before the examples:

*   UNIQUE compares **whole rows**. With a range of two columns, a row is a duplicate only if both cells match.
*   It keeps the **original order**. Wrap it in SORT if you need another one.
*   The result **spills** into the cells below and to the right of the formula, so they must be empty.

## Distinct values and unique values are not the same

By default UNIQUE returns **distinct** values: every value once, however many times it appears. With exactly\_once set to TRUE it returns **unique** values in the strict sense: only the values that appear a single time.

Take a list of customers with one row per purchase. This lists every customer once:

> `=UNIQUE(B3:B15)`

![Using the UNIQUE function in Google Sheets to extract distinct Values from a dataset.](https://cdn.owox.ai/www/webflow/67872545edd6741d1175674a_54100.png/public)

And this lists only the customers who bought **exactly once**:

> `=UNIQUE(B3:B15,,TRUE)`

![Using the UNIQUE function in Google Sheets to extract unique values from a dataset.](https://cdn.owox.ai/www/webflow/67872545ec7f3c1def497642_54102.png/public)

The two commas skip the by\_column argument. The first result answers “who are our customers”, the second “who never came back”.

## 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

## UNIQUE function examples

### List the distinct values of a column

A table of advertising campaigns has the ad type in column E. To see which ad types are in use:

> `=UNIQUE(E3:E15)`

![Unique values extracted from a dataset using the UNIQUE function in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a08936d2fd6713122e29_AD_4nXfpu6EHAwnDC-EeY2sKdCzA_z5B5yMF93lGfLiP1vaV5qKhzJVxwHOAO-MIzyHRTVxVagN9k-dGnr-7X7syOOHbl0q3JEE-ed_Pt1DuGV1hpUbife1N4uEW7-1WB0ZFITOtCI1VcQ.png/public)

To cover a whole column, including rows added later, use an open range such as `=UNIQUE(E3:E)`.

💡 _UNIQUE returns a clean copy and leaves the source as it is. To delete the duplicate rows themselves, see our guide on how to_ [_remove duplicates in Google Sheets_](/blog/articles/remove-duplicates-google-sheets)_._

### Distinct rows across several columns

With customer names in column B and purchase dates in column C, this returns each **customer and date pair** once:

> `=UNIQUE(B3:C15)`

![Using the UNIQUE function in Google Sheets to find distinct values across multiple columns.](https://cdn.owox.ai/www/webflow/6818a089c665904a4c0a256b_AD_4nXdL3JtLxT8uwvyWdP5tK-Sxd51fAqYqoIvdNr4Knps44gkUqu5PtWdPvSezsxuaS4wTCrFE8f36EasBxE2J-mlI7ejZp5G835-s4oCi3mVQy0QXOSZSrZRkWTGWFEIbi29m4qpE-g.png/public)

A customer who bought on two different days appears twice, because the rows differ in the date.

### Distinct columns in horizontal data

When each campaign is a column instead of a row, set by\_column to TRUE and UNIQUE **compares the columns**:

![Extracting unique values from horizontal data using the UNIQUE function in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a08ad9afa78836d2dbb8_AD_4nXdYRPLdoAe4f3vjc8WhXlruZOKkE_6lZvdeG3YAYAAOgtdEtP0LegMc2F_jOA78tSh79t6MdTCyr-LzUGTbxLVlVPdFUdCbFfnlivWEIp3RRvxkmyzXEfv-UH1yl7y8BzV0rORreQ.png/public)

> `=UNIQUE(C3:H5, TRUE)`

Campaigns with the same channel, region and ad type collapse into one column, which shows at a glance which setups are repeated.

### A drop-down list without duplicates

A drop-down built from a raw column repeats every value. Build it from a UNIQUE list instead.

1\. In an empty column, list the distinct products with `=UNIQUE(C3:C15)`. Here the formula is in cell E3.

![Creating drop-down menus based on unique values in a list using the UNIQUE function in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a08991f52808799a062f_AD_4nXeLgzwG0tND02LRlXQDdHCyP2c57QnI5Ygw49JFBM_f4LlChg3--DlsNXA52hL2F4E9JPBU3lS6RPy7V6NtoPp7k9cHtGcViNhPOVa1vmHBxhEJyRm7jol1Rb96TJaaOxqYeHCT_A.png/public)

2\. Select the cells that should get the drop-down.

3\. Go to **Data → Data validation** and add a rule.

4\. Under **Criteria**, choose **Dropdown (from a range)** and enter the range of the distinct list, here E3:E9.

5\. Click **Done**.

![Alternative method for designing drop-down menus using the UNIQUE function in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a089994a751232158429_AD_4nXdJIwFjDBViw6zyzPRmc-GwiNTInObnkOrlwxjzN_U_uHSO2YpJaP7lhAZBegOR7ZYS8WXFIuYeOB-ozuBsfjjhLcfLf9F_EabZEo-032n-nyF3WSbriCbSTc5ZqZQ4GGlFk-JxiQ.png/public)

For an **alphabetical** drop-down, sort the list first with [SORT](/blog/articles/sort-and-sortn-functions-google-sheets):

> `=SORT(UNIQUE(C3:C15), 1, TRUE)`

![Using the UNIQUE function in Google Sheets to create alphabetically sorted drop-down menus.](https://cdn.owox.ai/www/webflow/6818a08971c3b0f193cf04bd_AD_4nXelGEAlqRu7pV4fAeH5hyOvKGMlJUqq_DdZaAsxhj3XmYAZjIjb8Eaccf1z2TCGirhzxsh-kgw6jqFMI16-d-R77dT-h12hQWdVvIVcb-d2EhkDnq31ox-wsSXn67L9nE3D2F-D_w.png/public)

The 1 is the column to sort by and TRUE means ascending order. The drop-down then follows the sorted list.

![Refined design for alphabetical drop-down menus with the UNIQUE function in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a0890564b8fdab35d556_AD_4nXdqX6TYIPPRJGnosd-XBr3JCqSre6ODYbP2KtzhMF8YadEK2J58Ul5Sgk0gOYhcwiR1QJk6nTI-GjVSczd8ynJ4nLy-ttfAKqFhKQ9Y_NI5F_9lkHgkx2F7ifWDYlYT5GboVgmHTA.png/public)

💡 _To summarize the same data by category instead of listing it, see our_ [_guide to pivot tables in Google Sheets_](/blog/articles/pivot-tables-google-sheets)_._

[![The Ultimate Guide to Pivot Tables in Google Sheets](https://cdn.owox.ai/www/webflow/6786e7caf07d6bb501399ec4_49088.png/public)](/blog/articles/pivot-tables-google-sheets)

## Combining UNIQUE with other functions

### UNIQUE and TEXTJOIN: the distinct values in one cell

TEXTJOIN joins an array into one string. Feed it the output of UNIQUE to list, for example, every channel used in your campaigns in a single cell:

> `=TEXTJOIN(", ", TRUE, UNIQUE(B3:B15))`

![Combining the UNIQUE function and Google Sheets TEXTJOIN for advanced data manipulation.](https://cdn.owox.ai/www/webflow/6818a089bb4fa580b667f202_AD_4nXeeRKOOfm_RQG4yGjqkR-DIdGf-JnkMpQsuMK7J_NpfJ9TN2zS7Tg7DmBSwx0JS0oBMe6WwO84uB2r8MbmpCAvnfNzyv9nR4RYln1o3YqERj-CtIUEmfVEWdkFIDjDy1Xv27RBPMg.png/public)

1.  **UNIQUE(B3:B15):** returns the distinct values of the range.
2.  **TEXTJOIN(“, “, TRUE, …):** joins them with a comma and a space. TRUE skips empty cells.

### UNIQUE and SUMIF: a total per distinct value

To [sum](/blog/articles/sum-functions-google-sheets) sales per region:

1\. List the regions once with `=UNIQUE(B3:B15)`, here in cell F3.

![Summing unique values by combining the UNIQUE function with SUMIF in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a089cf260b686b1be8a1_AD_4nXceoOK0Pj9MCtxguDHIawDCyVoXYMxIluXR9mQi4U_ZYgoArbR_Nu7ubLy2GzPjFGG-jfizXdgijdpe6LY9tt3JBjIjN4cq7pS8_2AAuJTRio7kW17BHVNkmsmcNENBBR1ZMiSg7w.png/public)

2\. Next to the first region, add up its sales:

> `=SUMIF(B$3:B$15, F3, C$3:C$15)`

3\. Drag the formula down to the last region. The dollar signs keep the ranges fixed while F3 moves.

![Alternative example of using the UNIQUE function with SUMIF in Google Sheets for summing unique data.](https://cdn.owox.ai/www/webflow/6818a089f2985fba5b8ef945_AD_4nXcpe7C2SkT952IP-lX_jep_lZMYE1JxXM9RyI-QYIeR_kBRW6LGJVncoz4VwtcXkUQq3rPEbg1L6rc1B_MKqebJHGAblRO1NJl0KqJgym6bPEhTDGffypYzAoAR7uMaFF-66Snn3w.png/public)

### UNIQUE and COUNTA: how many distinct values

[COUNTA](/blog/articles/count-and-counta-in-google-sheets) counts the non-empty cells of what UNIQUE returns, which gives the **number of distinct values**:

> `=COUNTA(UNIQUE(B3:B15))`

![COUNTA Syntax being displayed in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a0895a447662893ffcd1_AD_4nXeh12payTK8XRj9lOP_HvHZzYxuhyC0Fld3gh7p8GkzQy3gBLRfR0uc5qS18l6WoV9mrhs2NZJzvuv14ca6rjWFClSuRa4OUDKwEl_4aBlykfE3N9RQeXupmv4GeQbjf5jxgCX3-Q.png/public)

![Advanced method for counting distinct values with the UNIQUE function and COUNTA in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a08907703f8c0dffdf23_AD_4nXcT0Eaexhy9f9SSvZE2An1Z4CfVdX94uSGcG6xIfU08c5KxPSbqL4zX99zcHh-4pNpA8ezWDRVe2b8pAe-vczWKs7UKn7ImvKRjGxY-lqY_lP1yxxkqlUnuZd77rINt5NgdxM2szw.png/public)

`=COUNTUNIQUE(B3:B15)` returns the same number in one function.

### UNIQUE and SORT: distinct rows in order

> `=SORT(UNIQUE(B3:C15))`

![Sorted list of unique sales representatives and their sales data in Google Sheets, combining UNIQUE and SORT functions to remove duplicates and organize information.](https://cdn.owox.ai/www/webflow/6818a089af1d529284e07f5c_AD_4nXf1opDtkk3JRDQkxfprMim98jUV9wWO9IIaBuI2LKBNTcTHGELdYxPEs2EFGNkbLORr0CJbGSCqX0FAelvXCJqO2-08JFCRdj9GvBjnrSFqWSuUUZymcC5_I-Z45eoOmIon-CEw.png/public)

The duplicate rows are removed first, then the result is sorted by the first column.

### UNIQUE and FILTER: distinct values that meet a condition

FILTER narrows the range before UNIQUE sees it:

> `=SORT(UNIQUE(FILTER(B3:B15, C3:C15 > 100)))`

This returns, in alphabetical order, each value of column B whose row has more than 100 in column C. The same pattern removes the blank entry that UNIQUE returns when the range contains empty cells: `=UNIQUE(FILTER(B3:B15, B3:B15 <> ""))`.

### UNIQUE and QUERY: distinct values from a query result

The query language of the QUERY function has no DISTINCT keyword, so wrap the query in UNIQUE. To list each customer who made a purchase on January 15, 2023:

> `=UNIQUE(QUERY(B3:C15, "select B where C = date '2023-01-15'"))`

![Filtering distinct values in Google Sheets using the QUERY function combined with UNIQUE to display only non-repeating rows.](https://cdn.owox.ai/www/webflow/6818a089c054341f59ca4c6d_AD_4nXdDFn4a0CsUYvnrb2Nsh-8tyPkFzNYNyU6XVzFJYD8JknMVlK8ZPfshvN5M6t8SN0zooDLpEIERPPy1P4JpGIEp1xAcTCsH9h_tNW19UTPL8q_KLR5XRIVpsD7FQTJBZdZLR6J7fw.png/public)

1.  **QUERY(…):** returns the customer names (column B) whose purchase date (column C) is 2023-01-15.
2.  **UNIQUE(…):** removes the repeated names.

💡 _More on this combination in_ [_QUERY with UNIQUE in Google Sheets_](/blog/articles/query-with-unique-google-sheets)_._

## Why UNIQUE returns values that look like duplicates

UNIQUE compares the cell contents exactly. Two cells that look the same to you can still differ.

### Different capitalization

**⚠️ Issue:** “Apple” and “apple” are returned as two values.

**✅ Solution:** Standardize the case first: `=UNIQUE(ARRAYFORMULA(LOWER(B3:B15)))`.

### Extra spaces

**⚠️ Issue:** “Apple” and “Apple “ (with a trailing space) are two values.

**✅ Solution:** Remove the spaces with TRIM: `=UNIQUE(ARRAYFORMULA(TRIM(B3:B15)))`.

### Numbers stored as text

**⚠️ Issue:** The number 100 and the text “100” are two values.

**✅ Solution:** Convert the column to one type, with VALUE for numbers or TO\_TEXT for text, before applying UNIQUE.

### An empty row in the result

**⚠️ Issue:** If the range contains empty cells, the result includes one empty entry.

**✅ Solution:** Filter them out: `=UNIQUE(FILTER(B3:B15, B3:B15 <> ""))`.

### Merged cells

**⚠️ Issue:** A merged cell holds its value in the top left cell only; the rest of the merged area is empty. UNIQUE then returns the value and an empty entry.

**✅ Solution:** Unmerge the cells (Format → Merge cells → Unmerge) and fill in the values.

## Errors in the UNIQUE function

### #REF!: the result has no room

The most common error. UNIQUE needs empty cells for its result. If any of them contains data, the formula returns #REF!, and hovering over it names the cell that is in the way. Clear the cells below and to the right of the formula.

#REF! also appears when the formula points to a tab that does not exist, for example after the tab was renamed or deleted:

> `=UNIQUE(Sheet8!B3:E15)`

![Solutions for addressing the #REF! error when using the UNIQUE function in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a0894d318987d36e7636_AD_4nXcW0F8w_81hCYe39Qp5xrcRP_2flNp9ib_hyS6W7z29ilWylPWz3isg0LEwmS-VG-xALvnBCLFwZYGuAl0L1w9Fup8modHvk6zcOKf_6-lKBgF5QAsNX0RM3VbKClhm-SZOJ0TlPg.png/public)

Correct the tab name in the formula.

### #VALUE!: the argument is not a range

> `=UNIQUE("Customer Names and Purchase Dates!", "B2:B200")`

![Troubleshooting the #VALUE! error encountered with the UNIQUE function in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a08946626fafe9eb425a_AD_4nXcmpOig4rUfb-7JRaNjpfRocAxIOQQzLIcn6_mDvmrABo8lMzAeXlqoJM463n5gUhC8cyK8fuRZ_LZ_QJkJJAsyOrms7zY4jfwaf5K2zRbd7oKqMfGE_xKdYQY1d3ZmRQYRejkZ.png/public)

Here the range was typed as two pieces of text. UNIQUE needs a range reference, written without quotes: `=UNIQUE(B2:B200)`.

### #N/A: the range is missing

![Steps to resolve the #N/A error in the UNIQUE function in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a08cebe7e46656ba1d42_AD_4nXeANxcbV44fbladNuoioFscQcJ-nQcNLVg2rc0K3wn5uNMAw5cPcNWj9x5k5RfRNxuqy1bDNeIkNH7eWuhbFsPNuZuFY9sjacnWmCHhgfGhcUWcLAQRQoNqv7T_ODKeVG8dU_5e0Q.png/public)

UNIQUE with no range, or with the wrong number of arguments, returns #N/A. Add the range.

### #NAME?: the function name is misspelled

> `=UNIQE(B3:B15)`

![Understanding and fixing the #NAME? error in the UNIQUE function in Google Sheets.](https://cdn.owox.ai/www/webflow/6818a08999c1466c395a20c6_AD_4nXdXkMhjuulfnSXvlwdMHLFahMFp8CjEfJZyNqCNDv0rKni3S0JkDpZ3qay6MO_23DdrBRaYa8LOjZAka5VOj8disnoqYHg2VGjt5iQ1OS3M5tVdobMhikLfHv-7DO24LYvgMkkbmA.png/public)

Google Sheets does not know a function called UNIQE. Correct the spelling to `=UNIQUE(B3:B15)`.

## Related Google Sheets functions

Functions that are often used next to UNIQUE, each with its own guide:

1.  [VLOOKUP](/blog/articles/vlookup-in-google-sheets): Searches the first column of a range and returns a value from the same row.
2.  [XLOOKUP](/blog/articles/key-differences-of-xlookup-vs-vlookup): A more flexible lookup that can return values from any direction.
3.  [MATCH](/blog/articles/google-sheets-match-function): Returns the relative position of an item in a range.
4.  [CONCATENATE](/blog/articles/query-with-concatenate-google-sheets): Joins several pieces of text into one string.
5.  [FILTER](/blog/articles/google-sheets-filter-function): Returns the rows of a range that meet your conditions.
6.  [IMPORTRANGE](/blog/articles/importrange-google-sheets): Imports a range from another spreadsheet.

## UNIQUE removes duplicates, it cannot say why they are there

A list with duplicates has usually been assembled by hand: two exports pasted under each other, a tab copied from last month, a join done with VLOOKUP that matched a customer twice. UNIQUE cleans up the symptom every time the sheet is opened. It cannot tell you whether the duplicated orders were also counted twice in the revenue column next to them.

The [OWOX Data Marts extension for Google Sheets](https://workspace.google.com/marketplace/app/owox_data_marts/94902851409) covers that half. A data analyst publishes a data mart (a table or an SQL query in your data warehouse) and makes it available for reports. In Sheets you open the extension, pick the data mart, tick the columns you want and run it. The rows land in a tab, ready for your formulas.

![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/unique-function-google-sheets/screens/1.png/public)

What changes for the person who maintains the sheet:

*   **Refresh replaces re-export.** _Refresh current report_ in the extension menu 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: whether an order appears once is decided there, in one place, and UNIQUE goes back to its real job of listing the distinct values in a column. 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

Why is my UNIQUE formula not working?

If your UNIQUE formula isn't working, check for empty rows/columns in your range, ensure the range is correctly specified, and verify that your data doesn't contain subtle duplicates.

How do I get unique (or distinct) values from another sheet in Google Sheets?

To get distinct values from another sheet in Google Sheets, use =UNIQUE(SheetName!range), replacing 'SheetName' and 'range' with the relevant sheet name and cell range. If you want to get a list of unique values you need to add the second parameter and set it to TRUE as in =UNIQUE(SheetName!range, , TRUE), so it will return only those values that appear exactly once in the range – what is identified as unique values.

How do I use COUNTA with UNIQUE?

Use =COUNTA(UNIQUE(range)). UNIQUE returns each distinct value once and COUNTA counts them, so the result is the number of distinct values in the range. =COUNTUNIQUE(range) returns the same number with one function.

How to extract distinct values based on criteria in Google Sheets?

To extract distinct values based on criteria, combine UNIQUE with FILTER: =UNIQUE(FILTER(range, criteria\_range=criteria)), specifying your range, criteria range, and criteria.

How to do a unique query in Google Sheets?

The query language of the QUERY function has no DISTINCT keyword. Wrap the query in UNIQUE instead: =UNIQUE(QUERY(range, "select B where C > 100")). For one row per group with totals, use group by inside the query.

How do you use the UNIQUE function in Google Sheets?

To use the UNIQUE function in Google Sheets, simply type =UNIQUE(range) where 'range' is the cell range you want to extract distinct values from.

## 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 · XLOOKUP vs VLOOKUP in Google Sheets: the key differences · October 2, 2026](/blog/articles/key-differences-of-xlookup-vs-vlookup)

[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)

[Google Sheets Tips · VLOOKUP in Google Sheets: formula, another sheet and examples · October 2, 2026](/blog/articles/vlookup-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
- [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.md
- [remove duplicates in Google Sheets](https://www.owox.com/blog/articles/remove-duplicates-google-sheets) — /blog/articles/remove-duplicates-google-sheets.md
- [SORT](https://www.owox.com/blog/articles/sort-and-sortn-functions-google-sheets) — /blog/articles/sort-and-sortn-functions-google-sheets.md
- [guide to pivot tables in Google Sheets](https://www.owox.com/blog/articles/pivot-tables-google-sheets) — /blog/articles/pivot-tables-google-sheets.md
- [sum](https://www.owox.com/blog/articles/sum-functions-google-sheets) — /blog/articles/sum-functions-google-sheets.md
- [COUNTA](https://www.owox.com/blog/articles/count-and-counta-in-google-sheets) — /blog/articles/count-and-counta-in-google-sheets.md
- [QUERY with UNIQUE in Google Sheets](https://www.owox.com/blog/articles/query-with-unique-google-sheets) — /blog/articles/query-with-unique-google-sheets.md
- [VLOOKUP](https://www.owox.com/blog/articles/vlookup-in-google-sheets) — /blog/articles/vlookup-in-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
- [MATCH](https://www.owox.com/blog/articles/google-sheets-match-function) — /blog/articles/google-sheets-match-function.md
- [CONCATENATE](https://www.owox.com/blog/articles/query-with-concatenate-google-sheets) — /blog/articles/query-with-concatenate-google-sheets.md
- [FILTER](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
- [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 · 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