Hi all,
This is my first post in the forum. I have greatly benefitted from the expert advice given here and hope you guys can help me with the following problem:
Status quo:
I have 12 workbooks, each of them structured in the same way in order to retrieve the data from an OLAP cube. Colum B:B contains financial accounts (Net Interest Income, Net Dealing Income, Liquidity Costs, etc.). In row C11:Z11 I have my 'managed regions' with the revenues in the individual accounts. Each workbook contains different company businesses.
Problem:
I am trying to rearrage the revenue data from the workbooks in a separate workbook that is structured as follows:
Column B: Accountlines
Column C: Accountline Shortcut
Column E: Region
Column F: Region Unique Identifier
Column G: Values
So far I have come up with a solution to extract the revenue data via an INDEX/MATCH function for one workbook only.
=INDEX(AIS!$C$12:$Z$186,MATCH('Rearranged'!$B5,AIS!$B$12:$B$186,FALSE),MATCH('EMC Rearranged'!$E5,AIS!$C$11:$Z$11,FALSE),1)
However I cannot INDEX/MATCH across more than one workbook. I played around with a LOOKUP/CHOOSE combination that I found in a thread which I believe has some similiarity to my problem but was not successful.
http://www.excelforum.com/excel-work...orksheets.html
I would appreciate if someone can help me finding a solution.
Many thanks in advance!
Bookmarks