| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use VLOOKUP to ref multiple workbooks with multiple tabs?
I have inherited a problem. I work with two multiple worksheet workbooks.
The first workbook is the "master" into which data from the second is pulled. In the formula pasted below, the phrase "Small Growth" is one of forty distinct worksheet names in the second workbook "expense stats.xls." Each worksheet is built identically to the other. =VLOOKUP($A$3,'C:\My Documents\[expense stats.xls]Small Growth'!$C$2:$G$2000,5,FALSE). The formula works but the "Small Growth" expression must be manually changed. I need a way to automate this. The names originate as values in $T4 of the INPUT worksheet in workbook one (the master). |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use VLOOKUP to ref multiple workbooks with multiple tabs?
Check out the INDIRECT formula. It would allow you to construct the text
inside the formula dynamically, so that you could pull the names of the different worksheets from an array where you'd keep them, for example. "JackieW" wrote: I have inherited a problem. I work with two multiple worksheet workbooks. The first workbook is the "master" into which data from the second is pulled. In the formula pasted below, the phrase "Small Growth" is one of forty distinct worksheet names in the second workbook "expense stats.xls." Each worksheet is built identically to the other. =VLOOKUP($A$3,'C:\My Documents\[expense stats.xls]Small Growth'!$C$2:$G$2000,5,FALSE). The formula works but the "Small Growth" expression must be manually changed. I need a way to automate this. The names originate as values in $T4 of the INPUT worksheet in workbook one (the master). |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use VLOOKUP to ref multiple workbooks with multiple tabs?
You coul use an INDIRECT referece in your VLOOKUP formula if "expense
stats.xls" is also opened. If not opened, you get a #REF error HTH -- AP "JackieW" a écrit dans le message de ... I have inherited a problem. I work with two multiple worksheet workbooks. The first workbook is the "master" into which data from the second is pulled. In the formula pasted below, the phrase "Small Growth" is one of forty distinct worksheet names in the second workbook "expense stats.xls." Each worksheet is built identically to the other. =VLOOKUP($A$3,'C:\My Documents\[expense stats.xls]Small Growth'!$C$2:$G$2000,5,FALSE). The formula works but the "Small Growth" expression must be manually changed. I need a way to automate this. The names originate as values in $T4 of the INPUT worksheet in workbook one (the master). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple vlookup | Excel Discussion (Misc queries) | |||
| Creating multiple workbooks from summary workbook | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| Combine contents of multiple workbooks into one worksheet | Excel Worksheet Functions | |||
| printing multiple sheet tabs to image file | Excel Discussion (Misc queries) | |||
Linear Mode
