How to use the SI.ND and ESNOD function to know if a cell has a value error

Who I am
Marie-Ange Demory

Author and references

Want to learn how to use the IF.ND and ESNOD functions to know if a cell has a value error? We have prepared this tutorial in which we will teach you very briefly how to use them. Have you ever wondered what they are and how to perform logical functions in Excel? Well, there are certainly many logic functions, from the IF function to SI.ND and ESNOD, which we will talk about later.

How to use the SI.ND and ESNOD functions to know if a cell has a value error

What are the SI.ND and ESNOD functions?

The SI.ND and ESNOD functions are used for view a result when the content of a search is not found. In other words, if a search was performed in the Excel table for a code or element that does not exist, the IF.ND and ESNOD functions will return a result.

In the case of SI.ND it is possible to set the message that will be displayed when the search is not found, instead with ESNOD only the term "false" will be displayed. When none of these functions are used, the message # N / A It appears instead.

The truth is that the # N / A message can be very inconspicuous, so using these functions could be helpful. In any case, we mainly recommend the SI.ND function, as the ESNOD function is simpler.

In any case, before starting, we recommend that you learn what the IF function is and what it is used for in Excel, the logical function par excellence that you should know, because it can help you better understand what we will mention below.

How to use the IFND and ESNOD functions to find out if a cell has a value error

We have two useful functions that we can use to show if our search result is not found, these functions are SI.ND and ESNOD. The application of each can be useful depending on the case.

Read Solution: "Netflix only closes when you open it or play any content"

SI.ND function

Process to use SI.ND function carefully follow the following steps:

  1. Go to the cell where the result # N / A is displayed, using the method we will present below, you will be able to change the message that appears when there is an error "not found" .
  2. To modify the message that appears on the screen, we will use the SI.ND function, with which we can appropriately modify the unpleasant message # N / A, replacing it with another more in line with the nature of our table.
  3. First of all we must indicate the value of the formula , in this case the value is relative to the VLOOKUP function, since the SI.ND function will show a false or true result by analyzing whether a requested value is in the table or not.

Part Two

  1. It will be necessary to indicate the cell we use to search for the content in the document, suppose the search cell is I7, that being the case, so far our code would go like this SI.ND(VLOOKUP(I7 .
  2. Similarly, following the previous step, you need to indicate the workspace and search, for this point the whole table, suppose the table goes from column A, to column E, if that's the case our code would go like this up to time SI.ND (VLOOKUP (I7; A: E.
  3. In turn, it will be necessary to indicate that column of the specific element you are looking for, assuming you have more elements, it will be necessary to indicate the appropriate column and the respective consequent value, which in this case will be FALSE, suppose it is column number 2 , if so, our code would go IF.ND (VLOOKUP (I7; A: E; 2; FALSE).
  4. The last step to syndicate that text that we want to be shown when the value is true, in this case it could be "the data doesn't exist". That way, our code would finally look like this: SI.ND (VLOOKUP (I7; A: E; 2; FALSE); "the data does not exist") .
  5. Press Enter, this way when a search is done and the result is finally not found, the message provided above will appear.
Read How to update Spotify to the latest free version? - Step by step

The truth is that the more logic functions you learn, the better prepared you will be to use this application. For example, knowing how to use the logical AND (AND) function in Excel is also essential in certain occasions, in turn the ESNOD function is essential.

The ESNOD function

While we mainly recommend Microsoft Excel's SI.ND function, the ESNOD function also has some usefulness, in case you want to use it, please read the following guide:

  1. The functioning of the ESNOD function is relatively similar to SI.ND, however it is not as efficient.
  2. To use the SNOD function, we will basically follow the same steps as the SI.ND function, so the final code would be as follows SNOD (VLOOKUP (I7; A: E; 2; FALSE) according to the previous example ) .
  3. Unlike the previous function, this one will only show the result as False.

As mentioned above, in order to use this office automation tool successfully, it is best to know all the options present. For example, the BASIC function in Excel is very useful, especially for databases and is one of those indispensable tools.

add a comment of How to use the SI.ND and ESNOD function to know if a cell has a value error
Comment sent successfully! We will review it in the next few hours.