Vlookup auto-update from another file

Closed
xHaxelx Posts 5 Registration date Tuesday September 11, 2012 Status Member Last seen September 18, 2012 - Sep 17, 2012 at 01:04 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 18, 2012 at 12:33 PM
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

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 17, 2012 at 06:40 PM
do a google search for a add on called "MOREFUNC". It can do what you want
xHaxelx Posts 5 Registration date Tuesday September 11, 2012 Status Member Last seen September 18, 2012
Sep 18, 2012 at 08:40 AM
The person who I send the file to, would they also be required have the add-on installed for the formula to work?
xHaxelx Posts 5 Registration date Tuesday September 11, 2012 Status Member Last seen September 18, 2012
Sep 18, 2012 at 08:58 AM
Does anyone know any alternatives? As this file will be viewed on multiple computers.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 18, 2012 at 12:33 PM
No, from what I recall this add on will be there embedded in the book itself