Creating Formula to retreive information from another workbook
Try it like this:
=INDEX('f:\ABC\FDR\[test.xls]Sheet1'!A1:Z1000,MATCH(B1,F:F,0)+1),12)
--
Biff
Microsoft Excel MVP
"caldog" wrote in message
...
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
|