I am trying to use a formula that uses INDEX function. In order to generalize for all the lines that sometimes may contain information from another sheet and sometimes they may not.

That's why I get an `ISREF` error within the cells because the corresponding cells in the other sheet can't be referenced.

I want to display a default value instead of the `ISREF` error message. I tried using `ISREF` function itself within an `IF` condition but it doesn't work on the same cell. It only references another cell because it is a cell checking function and it doesn't check the output of a formula.

I tried also `ISERROR` function but it didn't work also. Here's a snippet of the formula that I am putting within my cell:'

```
INDEX(Plagesuivi; $Q203; 9)

```

* Plagesuivi is a named range
* $Q203 contains the row number (that I fetch dynamically and correctly)
* 9 is the column number

P.S. The indexing is working fine with cells that do appear is the named range: Plagesuivi