This video demonstrates how to create absolute references to columns in Excel Tables. Formulas that refer to Excel Tables use Structured References rather than normal cell references. You cannot use dollars or the F4 key to generate absolute references in this context. This video shows you what you need to do instead!
------------------------