A prominent case for INDEX()...

=INDEX(B54:I54,A13)

J-Philippe wrote:
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