In other words, create a formula that can refer to an Excel table by name as a variable.
This allows the same formula to be used in L5:L7.
The trick is the INDIRECT function to evaluate the reference.
Note: INDIRECT is a volatile functionand can cause performance issues in larger, more complex workbooks.
INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.
