Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Formula to retreive information from another workbook
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Formula to retreive information from another workbook
Thanks I must have been having a bad day not to realize what I needed
to do. Thanks for the clue. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Formula to retreive information from another workbook
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "caldog" wrote in message ... Thanks I must have been having a bad day not to realize what I needed to do. Thanks for the clue. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I retreive deleted information? the file was saved | Excel Discussion (Misc queries) | |||
How do I retreive a replaced excel workbook? | Excel Worksheet Functions | |||
creating a formula that condenses information in a cell | Excel Worksheet Functions | |||
Creating a formula to populate information from multiple cells in another workbook | Excel Worksheet Functions | |||
Retreive information from One Sheet to Another | Excel Discussion (Misc queries) |