| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Referring to Cells in a forumula using a function
I want to be able to refer to a cell in a formula using a function. So
normally I would refer to a cell as R1C1 using RC type of reference. But say I want to refer to cell R1C(myFunction(R2C2)). myFunction(R2C2) would return a value which would specify which column the cell is in based on the contents of R2C2. So if the function returned "2", the I would get cell R1C2. Is this possible? Thanks LRL |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function to find which cells add up to a given total? | Excel Worksheet Functions | |||
| Use TREND function with nonadjacent cells | Excel Worksheet Functions | |||
| Conditionial formatting for merged cells, function Len($A$4) | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| i want to use the =if function to apply a colour to other cells | Excel Worksheet Functions | |||
Threaded Mode
