Using a cell reference to create part of a cell reference.

In my 8 years of excel experience I have yet to find a way to use a cell reference to create a part of another cell reference for example if I want my formula to be =A# and I want the # to varry based on the value from cell Z3. This has been plagueing me forever and had me stumped and banging my head for hours to find some alternative solution. Is there some sort of combination of functions or simple solution?

What I want is simply =A(Z3) to output "Value" when Z3=1 and A1="Value"

Any Help would be much appretiated!

You can use INDIRECT or INDEX, like

=INDIRECT("A"&Z3)

=INDEX(A:A,Z3)