Share via

Saving a table array as a variable

Anonymous
2022-07-21T08:50:30+00:00

Hi, I am trying to use the Vlookup function to bring in data from a new spreadsheet every month is there a way to save the table array as a variable or refer to the data in a cell so I can just add a new file path once rather than changing it on each cell?

For example

=vlookup(A1,'Variable',2,0)

where 'Variable' is the file path and table array

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2022-07-21T09:00:13+00:00

    You can use INDIRECT as long as the source file will be open, but in my opinion you're better off just using the Edit Links command on the Data tab if you need to change all the formula links to point to a new file.

    Was this answer helpful?

    0 comments