On Tue, 25 Jun 2013 07:33:20 +0100, Walter Briscoe wrote:

I run Excel 2003 on a Windows Vista system.

I have an application in which I want to map non-negative integers to
text. I tried using OFFSET.

A B C D E
1 Clubs Dimonds Hearts Spades NoTrump
2 0 Clubs



I am looking for a better way of including array constants within
formulas, rather than in cells.


You can use the INDEX function with an array constant:

=INDEX({"Clubs","Diamonds","Hearts","Spades","NoTr ump"},A2+1)