Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel: how to formulate conditional cell references
would like to build a cell that contains the contents of a series of cells on
a different worksheet depending on a selection criteria: Example: On Sheet 2 Cell D23: If January, cell will contain a reference to Sheet1 cell A5 If February, cell will contain a reference to Sheet 1 cell B5 etc. |
#2
|
|||
|
|||
You can take advantage of the fact that January is month 1, feb is month 2,
etc. Say A1 = 1/1/2004 (january month =1) Here is one way of going about it; =INDIRECT(ADDRESS(5,MONTH($A$1))) "centraloffice" wrote in message ... would like to build a cell that contains the contents of a series of cells on a different worksheet depending on a selection criteria: Example: On Sheet 2 Cell D23: If January, cell will contain a reference to Sheet1 cell A5 If February, cell will contain a reference to Sheet 1 cell B5 etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |