Problem with IF condition or vector lookup?

G

Guest

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
 
R

RagDyeR

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!
==============================================


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
 
G

Guest

=IF(OR(A13={1,2,3,4,5,6,7,8}),INDIRECT(CHAR(CODE(A13)+17)&"54"),"error")

HTH
Jason
Atlanta, GA
 
G

Guest

Thanks all for your quick reply and great help.
The Index solution works perfectly.
J-Philippe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP with a blank cell 5
IF Statement problem 3
OR function in a SEARCH not working 1
Format linked workbook cells (updated) 2
If Statement to subtract “time†if condition met 7
IF Formuala 4
Problem with Using "Multiply by 1" 5
Lookup value with multipe Results 5

Top