Shorter doesn't mean more transparent and effective.
My solution of 2nd question is:

=INDEX($E$18:$H$21;COUNT(E18:E$21);COUNT(E18:$H18))

Which doesn't use nor hard coded values, no cells...