Updating information in one excel file from another excel file

[Iris Stein]

I have an excel file that contains information that I have been collecting manually from other excel files. I would like to create a formula that would automatically update the information when it is entered in one excel file to the other excel file.

I've tried using VLOOKUP with INDIRECT with the following formula

=VLOOKUP(D1,Indirect.ext("C:\Product\Operator Excel Sheets\["&Mobile Daily Report&".xls]Jan '15'!$A$:$D$44"),4,FALSE)


but I am receiving an error message. I am certain that the file location and file name are correct, but the message error I am getting is #NAME?.

Could anyone suggest what is causing the error OR suggest another way of going about this?

Thanks in advance!

 

[NARAYANK991]

Hi Iris ,

Quite a few changes to be made :

=VLOOKUP(D1,INDIRECT("'C:\Product\Operator Excel Sheets\[Mobile Daily Report.xls]Jan ''15'!$A$4:$D$44"),4,FALSE)

The characters in RED are the single quote character ' , which is required when ever your file name has spaces within it.

The characters in GREEN are the double quote character " , which is required when ever you use the INDIRECT function with a literal parameter.

The digit 4 in BLUE is an arbitrary number I have inserted since it is missing in your formula ; you will need to replace this by a number more appropriate to your data layout.

Narayan