Reference a workbook based on a cell reference

  • Thread starter Thread starter douga
  • Start date Start date
D

douga

Is there a way to reference in a formula another workbook based on a
cell reference. Example: If cell a1 contains the value "Jan", I want to
be able to have the formula say look at cell a1 and then lookup a value
in that workbook called Jan.

Thanks
 
Back
Top