We have already learned 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 function. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- To get the position of the error, you can use the below formula.
Syntax Explanations:
- TRUE – This function will return the value TRUE if the given conditions will be TRUE. Read more on the TRUE function.
- ISERROR – In Excel, the ISERROR function will help to return TRUE for any error type excel generates, including #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!
- MATCH – The MATCH functionin 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 B.
- Enter the given formula in the formula bar section.
- After applying the formula, Press CTRL + SHIFT + ENTER Keys.
- It will find out the first error and return the position in the selected cell.
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.
Top comments (0)