Using a linear search to find a value that is stored in the last element of an array of 20,000 elements, 20,000 element(s) must be compared.
Structured references make it easier to use formulas with Excel tables by ... Use brackets around specifiers All table, column, and special item ...