One way:
=index(1:1,b2)

Another:
=indirect("r1c"&B2,false)

The top one will only recalc when required.
The second one will recalc whenever excel recalcs.







igorek wrote:

I want to create a formula that will at cell R1C1. However, the C1 part needs
to be variable. Here is the example of what i think it should be:

=R1C" & B2 & "

this formula needs to return Row1 and column number whosw the value located
in the cell B2. Lets say B2 has a number 70 in it. The result of the formula
i need to return is the value located in R1C70

Please help, because my brains are exploding

--

Dave Peterson