Excel Formulas to Find the First Error Using MATCH function!!
Tags: excelformula, excelformulas
Published: 2021-01-18 11:12:30

---
title: Excel Formulas to Find the First Error Using MATCH function!!
published: true
date: 2021-01-18 10:31:56 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-position-first-error-match/
---

We have already learned [How to Select Cells with Error Values in Excel Office 365?](https://geekexcel.com/how-to-select-cells-with-error-values-in-excel-office-365/). For instance, you want to find out the position of the error value means what would you do? Are there any good ways to deal with this problem quickly in Excel? Not to worry, here we will show the simple formula to **find the first error in Excel** using the **[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)** function. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Find the position of the first error](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Find-the-position-of-the-first-error.png)](https://geekexcel.com/excel-formulas-find-position-first-error-match/find-the-position-of-the-first-error/#main)<figcaption id="caption-attachment-21084">Find the position of the first error</figcaption>
## General Formula:

- To get the position of the error, you can use the below formula.

**=[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)([TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/),[ISERROR](https://geekexcel.com/how-to-use-iserror-function-in-microsoft-excel-365/)(range),0)**

## Syntax Explanations:

- **TRUE** – This function will return the value TRUE if the given conditions will be TRUE. Read more on the **[TRUE function](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)**.
- **ISERROR** – In Excel, the **[ISERROR function](https://geekexcel.com/how-to-use-iserror-function-in-microsoft-excel-365/)** will help to return TRUE for any error type excel generates, including **[#N/A](https://geekexcel.com/how-to-replace-n-a-or-zero-in-vlookup-with-blank-or-specified-text-in-excel/)**, **[#VALUE!](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/)**, **[#REF!](https://geekexcel.com/how-to-fix-ref-error-in-excel-office-365-with-example/)**, **[#DIV/0!](https://geekexcel.com/how-to-fix-div-0-error-in-excel-office-365-with-example/)**, **[#NUM!](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/)**, **[#NAME?](https://geekexcel.com/how-to-fix-name-error-in-excel-office-365-with-example/)**, or **[#NULL!](https://geekexcel.com/how-to-fix-null-error-in-excel-office-365-with-examples/)**
- **MATCH** – The [**MATCH function**](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)in Excel is used to locate the position of a lookup value in a row, column, or table
- **Range** – It is the input data.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Now we are going to see how to get the position of the first error value in Excel. Refer to the below image.

- Here, we will enter the input values in **[Column](https://geekexcel.com/excel-office-365-columns/) B**.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Range-8.png)<figcaption id="caption-attachment-21077">Input Range</figcaption>

- Enter the given formula in the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section.

![Enter a formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-a-formula-12.png)<figcaption id="caption-attachment-21078">Enter a formula</figcaption>

- After applying the formula, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- It will find out the first error and return the position in the selected **[cell](https://geekexcel.com/combine-text-from-two-or-more-cells-into-one-cell-in-excel-365/)**.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-29.png)<figcaption id="caption-attachment-21079">Result</figcaption>

## Conclusion:

Hope you understood the formula, and it helps you to **get the position of the error values** on your worksheet. If you have any **doubts** regarding this article, don’t forget to let me know. I reply to **queries** frequently.

### Related Articles:

- **[Replace Formulas Error Messages with Zero, Blank Cells, or Text in Excel!!](https://geekexcel.com/replace-formulas-error-messages-with-zero-blank-cells-or-text-in-excel/)**
- **[Excel Formulas to Count Cells that do not contain Errors!!](https://geekexcel.com/excel-formulas-to-count-cells-that-do-not-contain-errors/)**
- **[Formulas for counting the cells that contain Errors in Excel Office 365!!](https://geekexcel.com/formulas-for-counting-the-cells-that-contain-errors-in-excel-office-365/)**