R1C1 format using a variable?

[jim37055]

Is it possible to use a variable to designate the column in R1C1 format?


If so, what is the proper way to do it?


Example:

R5C"my variable goes here"

 

[JE McGimpsey]

One way:

=INDIRECT("R5C" & myVar,FALSE)

Another way:

=INDEX(R5,myVar)

 

[bj]

check out indirect() in help

 

[jim37055]

Thanks guys, that worked.