Try:

=Choose(A1+1,123,456,789)

or if you have a list, say in X1:Y3

=Lookup(A1,X1:Y3)


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109445