Basically the problem boils down to - how do I use a named reference/range within array in an Excel spreadsheet formula?

Example:

```
={"this","is","my","house"}

```

Produces 4 cells in one row with correct text

But this

```
={"this","is","my", House}

```

where House is a named range of a cell containing some text fails.