Resolve dynamic column referencing in Excel 2016 by using INDEX MATCH or INDIRECT to convert cell text into live table column references.
Read MoreResolve Excel formula propagation errors when dragging down values from arrays referenced by table columns.
Read More