Learn about the implicit intersection operator (@), which returns a single value using logic known as implicit intersection. The implicit intersection operator (@) may return a value, single cell range, or an error. The implicit intersection operator (@) is in a class of functions called dynamic arrays.| support.microsoft.com
How to correct a #SPILL error in Excel (when a formula returns multiple results and cannot return them to the grid).| support.microsoft.com
Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.| support.microsoft.com
A complete list of all Excel functions in alphabetical order.| support.microsoft.com
Learn how the Excel MATCH function locate the position of a specific value within a given range or array with dynamic lookups, advanced examples, and best practices.| Excel