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.

Learn how to fix #SPILL formula errors in Microsoft Excel. Skip to ... this style of formula will return a dynamic array but does not work with Excel tables. Method 2: Reference the value on ...