Excel If function alternative

[Guest]

hello

In my spreadsheet, I've been using a nested if function, but now I need to
expand it to 12 if statements and since there is a max of 8, basically my
formula is this

If a1=1, z1, if a1=2, z2, if a1=3, z3 and so on. What other function can I
use to do this

 

[Guest]

You might try:
=choose(A1,Z1,Z2,Z3,Z4,Z5,Z6,Z7,Z8,Z9,Z10,Z11,Z12)

Will that work for you?

Ron

 

[Peo Sjoblom]

=INDEX(Z1:Z12,MATCH(A1,{1;2;3;4;5;6;7;8;9;10;11;12},0))

 

[CLR]

Classic application for the VLOOKUP feature. Put 1 in Y1 and fill down to
Y12........

Then in B1(or whereever), put this formula

=VLOOKUP(A1,Y1:Z12,2,FALSE)


Vaya con Dios,
Chuck, CABGx3

 

[Bob Phillips]

Everyone is guessing as you don't show what you already have. Give us some
help.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Dana DeLouis]

Would this work? This has no error checking.

=INDIRECT("Z" & A1)

 

[Aladin Akyurek]

hello

In my spreadsheet, I've been using a nested if function, but now I need to
expand it to 12 if statements and since there is a max of 8, basically my
formula is this

If a1=1, z1, if a1=2, z2, if a1=3, z3 and so on. What other function can I
use to do this

If A1 = 1,2,3,...,N, then:

=INDEX(Z-range,A1)

should suffice.