Excel: how to formulate conditional cell references

[Guest]

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.

 

[Dave R.]

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)))