Thread: [Solved] Doing a data look up
View Single Post
 
Old 04-09-2011, 10:41 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Ashan

If your 'Index' values are stored as a master list in the summary workbook, you could use a LOOKUP formula to retrieve to values from each of the other workbooks.

If your 'Index' values are not stored as a master list in the summary workbook, you would need a macro-based solution that would open each source workbook, check its index entries against those that might (not) already be in the summary workbook and if, not found in the summary workbook, add the index entry. You can then use the formula approach mentioned above, or have your macro copy the value to the relevant column for the index row.

As you can see from the above, one possible solution is fairly simple and can use just formulae; the other is much more complex and requires a macro for at least part of the process.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote