How to setup a spreadsheet that can hold more than one set of dimensions? Let's say Column A holds names of dimensions and column B holds values that are referred from other objects. Let's say I want to have several sets of alternative values in the following columns (C, D, E etc.) and I want to choose which set to use with a single switch (and without moving columns around).
For example cell B1 holds the letter of the column I want to use and formulae in every row in column B refers to B1 and chooses value from the current row and the column stored in B1. (Such references might work for rows and single columns as well. In the real spreadsheet this can be achieved with the INDEX()
The best example (aside from having the same design for a small box and a large one) is conversion between imperial and metric systems
. Although conversion from inches to millimeters is mathematically straightforward, it cannot be applied directly to every single dimension, because some tools and parts have fixed dimensions and we own only one set of them (e.g. metric drill bits, bolts) and it needs to be manually specified and explicitly stated whether to use 3/8" or 13/32" instead of 10 mm.
Of course having small box and a large one in a single design is also nice.