Vlookup auto-update from another file

[Closed]
Report
Posts
5
Registration date
Tuesday September 11, 2012
Status
Member
Last seen
September 18, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have this formula here:

=IFERROR(VLOOKUP(T15,INDIRECT(CONCATENATE("'C:\Documents and Settings\[",$C$7,".xls]",$C$6,"'!$E$3:$S$200")),11,FALSE),0)

The main function of this formula is a vlookup function on a specific file to a specific worksheet.

$C$7 = specifies the name of the file
$C$6 = specifies the name of the worksheet in that specific file

The issue I have been having is that the formula is unable to extract the vlookup information, unless I have the specific file open. Are there ways around this issue? Perhaps a different formula?

Sincerely,
xHaxelx

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
do a google search for a add on called "MOREFUNC". It can do what you want
Posts
5
Registration date
Tuesday September 11, 2012
Status
Member
Last seen
September 18, 2012

The person who I send the file to, would they also be required have the add-on installed for the formula to work?
Posts
5
Registration date
Tuesday September 11, 2012
Status
Member
Last seen
September 18, 2012

Does anyone know any alternatives? As this file will be viewed on multiple computers.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
No, from what I recall this add on will be there embedded in the book itself