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. |
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. |
All times are GMT +1. The time now is 03:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com