Linking to another spreadsheet in a dynamic way

A

alves

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
 
Top