Dynamic Indexing in Excel
Dynamic indexing in Excel allows you greater flexibility when building a spreadsheet. This skill will enhance formulas such as VLOOKUP(), SUMIF(), and INDEX(MATCH)). It will also provide more options for pivot tables, charts, and analysis.