| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change cell reference within formulas
I have some formulas that refer to other workbooks. I want the formula to
point to a different column, depending on the current month; e.g., in January, the data will be in column E (and relative row references), in February, the data will be in column F, and so on. How do I create the formula with the cell reference as a "Variable" that can refer to other cells where the correct column identifier is indicated via the VLOOKUP function, or is just entered? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the default cell reference from absolute to relati | Setting up and Configuration of Excel | |||
| Reference Cell Color From Other WorkSheets | Excel Worksheet Functions | |||
| Cell Reference with Range Name | Excel Worksheet Functions | |||
| How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
