Vlookup function with variable file names

  • Thread starter Thread starter Gaurav
  • Start date Start date
G

Gaurav

Hi,

I need your help on this-
I want to vlookup data from different excel spreadsheets without
opening that particular file. Is that possible to link file path/name
and columns to be looked upon in the Vlookup formula as file names
would change every month, so that I don't have to enter the vlookup
formula again and again. And I only have to change the spreadsheet
name to change the vlookup formula. Would Indirect function be useful
in this case?

Thanks,

Gaurav
 
Back
Top