| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
R1C1 formula question
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
| Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Discussion (Misc queries) | |||
| Question on this conversion code switching between r1c1 to A1 format tia sal2 | Excel Worksheet Functions | |||
| Question About Accessing Web Info Using R1C1 | Excel Worksheet Functions | |||
| R1C1 Formula in Excel | Excel Worksheet Functions | |||
Threaded Mode
