Take a look as VLOOKUP. Something like this in F1:

=vlookup(a1,b1:c3,2,0)

Where you would enter 1, 2, or 3 in a1.
Where b1 = 1, b2 = 2, b3 = 3.
Where c1 = apple, c2 = pear, c3 = orange.
The 2 points to the second column of b1:c3 table
The 0 demands an exact match.

HTH
Regards,
Howard

"Formula help" <Formula wrote in message
...
I am trying to find a way to have a number or letter represent certain cell
contents so that when I type that number or letter into a new cell it will
automatically fill with the represented cell contents. Example: cell A1=
Apples and I want 1 to represent the contents in A1 which is Apples so
that
when I enter 1 into cell A2 the word Apples automatically fills in for
cell
A2.