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).

If your formula is entered incorrectly, Excel will not auto calculate. The formula will not calculate due to a space entered before the equal sign or an apostrophe is entered as a part of the ...

There’s a fix, and it’s simpler than you might think. My Online Training Hub uncover the one thing Excel tables consistently get wrong: their inability to reliably lock column references.