News

When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.
Having an incorrect row or column in your INDEX formula can trigger the #REF error, for instance, in the photo above, we have an incorrect row (7) and an incorrect column (4).