I'd like to know if it is possible to select a cell by the header / row name?
I know I can select the number of working days using
B2, but is there something more elegant like Days[Work] ?
A B C 1 Class Days 2 Work 220 3 Sick 5
You can select that cell by almost exactly that method, with a tiny bit of setup on your worksheet.
For Excel 2007 - 2010: you can convert the data into a Table. Select the range and from the Home tab choose Format as Table. Pick a style (you can change or remove this formatting later), verify the selected data and choose "My table has headers".
How you then reference that data point depends on how complex your table is. In an empty cell try typing = then clicking the cell you want to refer to. You will get a formula like
For older versions of Excel (and new ones too!): you can define range names for this data. This is as simple as selecting a range and typing in the name box which is found to the left of the formula bar. A more efficient way is to select the range and go to Formulas > Create from selection (shortcut CTRL SHIFT F3). This will create a whole stack of range names for you to play with. These can be browsed from the Name Manager dialogue. Usage could then be something like
You can name a cell or a range.