View Single Post
  #1   Report Post  
centraloffice
 
Posts: n/a
Default 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.