Most spreadsheet problems come from static cell ranges—Excel tables replace them with dynamic, self-managing data structures.
Those of us over a certain age will remember using paper lookup tables for logarithms or trigonometry functions. Those who are younger will have been exposed to lookup tables in their programming ...