Creating Formula to retreive information from another workbook

[caldog]

Each morning I automatically have bank information that is download to
a company server in the excel format. What I am needing is a formula
that will go and get particular information for my report. I know
that I can use this formula on the downloaded workbook that is coming
from the bank [INDEX(A1:Z1000,(MATCH(B1,F:F,0)+1),12)], and it will
get me the right information. Now I have a second workbook that is on
my hard drive that, that I need to pull from the downloaded workbook.

I tried using something like this ['f:\ABC\FDR\[Test.xls]Sheet1'!
INDEX(A1:Z1000,(MATCH(B1,F:F,0)+1),12)], but of course it is not
working so what am I doing wrong?

Steve

 

[T. Valko]

Try it like this:

=INDEX('f:\ABC\FDR\[test.xls]Sheet1'!A1:Z1000,MATCH(B1,F:F,0)+1),12)

 

[caldog]

Thanks I must have been having a bad day not to realize what I needed
to do. Thanks for the clue.

 

[T. Valko]

You're welcome. Thanks for the feedback!