Reference a workbook based on a cell reference

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Excel - Wich Function should I use? 1
Multiple Criteria, One Answer 1
Reposition Cells in a Column based on another 2
Is there a function to count how many times a cells value is used? 0
Converting a number into a cell reference 2
Mapping integers to strings 6
Referencing another workbook using a variable for the sheet? 20

Top