Creating Formula to retreive information from another workbook

C

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

T. Valko

Try it like this:

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

caldog

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