Using the Value in a Cell to identify

[knowtrump]

Is it possible to use the value in a cell to get the value in another cell? e.g. Cell e4 contains the value 12, is there any function that I can use to get the value in cell a12 using e4? i.e. a"function"(e4)

[Rowan Drummond]

=INDIRECT("A" &E4)

Regards
Rowan

knowtrump wrote:
> Is it possible to use the value in a cell to get the value in another
> cell? e.g. Cell e4 contains the value 12, is there any function
> that I can use to get the value in cell a12 using e4? i.e.
> a"function"(e4)
>
>

[knowtrump]

Thanks Rowan, it works!

[Rowan Drummond]

You're welcome.

knowtrump wrote:
> Thanks Rowan, it works!
>
>