Try this:

=CHOOSE(A13,B54,C54,D54,E54,F54,G54,H54,I54)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"J-Philippe" wrote in message
...
Inserting more than 8 conditions into one cell?

Hi, I'm trying a basic look of 8 conditions, but it seems that the formula
is too long. I've tried to use lookup but I can't get it to show the cell
results instead of a specific number or letter.

I'm just trying to do this in one cell (i.e in cell C16):

if cell A13=1 show result content of cell B54
if cell A13=2 show result content of cell C54
if cell A13=3 show result content of cell D54
if cell A13=4 show result content of cell E54
if cell A13=5 show result content of cell F54
if cell A13=6 show result content of cell G54
if cell A13=7 show result content of cell H54
if cell A13=8 show result content of cell I54

I just can't get it to work. Anybody could tell me what the formula in cell
C16 should look like?
Thanks a lot
J-Philippe