One way:

=INDIRECT("R5C" & myVar,FALSE)

Another way:

=INDEX(R5,myVar)

In article ,
jim37055
wrote:

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"