Linking to another spreadsheet in a dynamic way
 

Hi everyone,

I am using a vlookup function:
=VLOOKUP(A25,MV_TD_MT_2004!$A:$G,G$2,FALSE)

In this formula will look for the values in spreadsheet MV_TD_MT_2004,
columns $A:$G.

I have 50+ spreadsheets MV_TD_MT_1953 to MV_TD_MT_2006

Is it possible to make the reference to the spreadsheet with the values
in a dynamic way?

I am trying to avoid using VBA on this one.

Thanks in advance.

PA

Linking to another spreadsheet in a dynamic way
 

You can use dynamic named ranges. See he
http://www.ozgrid.com/Excel/DynamicRanges.htm

Dave
--
Brevity is the soul of wit.


"alves" wrote:

Hi everyone,

I am using a vlookup function:
=VLOOKUP(A25,MV_TD_MT_2004!$A:$G,G$2,FALSE)

In this formula will look for the values in spreadsheet MV_TD_MT_2004,
columns $A:$G.

I have 50+ spreadsheets MV_TD_MT_1953 to MV_TD_MT_2006

Is it possible to make the reference to the spreadsheet with the values
in a dynamic way?

I am trying to avoid using VBA on this one.

Thanks in advance.

PA