INDEX Inquiry

Airam

New Member
Joined
Jun 23, 2010
Messages
13
Hi Everyone

I have a template which is link to an external file using Index and Vlookup. However, as the external file changes its Location or tab name, I also need to also make adjustment in my formula to be able to return the value I am looking for. Since I am looking for a lot of data in different files, updating formula one by one is very time consuming and prone to error.

I am thinking if there's any way I can just put the link of the external file in a cell and the Tab name on another cell and every time I change the Link or tab name, Index formula will also adjust to look for the data based on that data.

Please see attached .jpg file. This is the current formula and set-up I am using. Hoping for your usual kind guidance.
 

Attachments

  • INDEX Inquiry.jpg
    INDEX Inquiry.jpg
    91.3 KB · Views: 7

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,118,603
Messages
5,573,175
Members
412,510
Latest member
shp0590
Top