Excel If function alternative

S

saborbas

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
 
R

Ron Coderre

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

Will that work for you?

Ron
 
C

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
 
B

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)
 
A

Aladin Akyurek

saborbas said:
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
Click to expand...

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

=INDEX(Z-range,A1)

should suffice.
 
Top