| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to create a variable column in cell reference
cell m2 refers to a letter determined by a formula.(for exmple D or F).
cell i10 uses the following formula with a cell reference to another sheet. I need the column cell reference to change to D if cell m2=D...or =ROUNDUP(D10*G10/DIRECTIONS!$D$56,0) I need the column cell reference to change to F if cell m2=F...or =ROUNDUP(D10*G10/DIRECTIONS!$F$56,0) How do i write the formula so that the column cell reference equals the letter in cell m2? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions | |||
| Name Box cell reference | Excel Worksheet Functions | |||
| Formula to reference column heading | Excel Worksheet Functions | |||
| Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
| name of another worksheet in cell for reference | Excel Worksheet Functions | |||
Threaded Mode
