I have just starting working with the new excel tables, but have been working with named ranges forever. In the past each cell in the table “Rates” would be a named range, but now are in two columns, “Level” and “Area”. How do I write Rate[Area] =“West” [Level] to return a single value?
I am...