Create a lookup table like this:

...........J..........K
1.......1........first
2.......2.......second
3.......3.......third
4.......4.......fourth
5.......5.......fifth

A1 = 3

B1 formula:

=VLOOKUP(A1,J1:K5,2)

--
Biff
Microsoft Excel MVP


"Michaeldc" wrote in message
...
I want to have an entry cell where you put numbers in and and output cell
which displays corresponding first, second, third etc