Would this work? This has no error checking.

=INDIRECT("Z" & A1)

--
Dana DeLouis
Win XP & Office 2003


"saborbas" wrote in message
...
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