| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup equation on multiple tabs
How do I use a vlookup equation on sheet 1 which contains a column with all
the tab names, eg 60093, 60094,....etc, to pull required data from the respective tabs. The equation i'm currently using is as follows =VLOOKUP($D30,'60093'!$F:$AS,25,FALSE) Any help would be much appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup equation on multiple tabs
Maybe...
=VLOOKUP($D30,indirect("'"&b$1&"'!$F:$AS",25,FALSE ) where b1 contains one of those worksheet names. bongiman wrote: How do I use a vlookup equation on sheet 1 which contains a column with all the tab names, eg 60093, 60094,....etc, to pull required data from the respective tabs. The equation i'm currently using is as follows =VLOOKUP($D30,'60093'!$F:$AS,25,FALSE) Any help would be much appreciated. Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup equation on multiple tabs
I was trying to get that indirect formula to work for ages before you posted
your reply. Apart from the missing closing bracket before ,25 it's perfect.....you're a genius! =VLOOKUP($D30,indirect("'"&b$1&"'!$F:$AS"),25,FALS E) "Dave Peterson" wrote: Maybe... =VLOOKUP($D30,indirect("'"&b$1&"'!$F:$AS",25,FALSE ) where b1 contains one of those worksheet names. bongiman wrote: How do I use a vlookup equation on sheet 1 which contains a column with all the tab names, eg 60093, 60094,....etc, to pull required data from the respective tabs. The equation i'm currently using is as follows =VLOOKUP($D30,'60093'!$F:$AS,25,FALSE) Any help would be much appreciated. Thanks -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup equation on multiple tabs
Oops. Glad you got it working.
bongiman wrote: I was trying to get that indirect formula to work for ages before you posted your reply. Apart from the missing closing bracket before ,25 it's perfect.....you're a genius! =VLOOKUP($D30,indirect("'"&b$1&"'!$F:$AS"),25,FALS E) "Dave Peterson" wrote: Maybe... =VLOOKUP($D30,indirect("'"&b$1&"'!$F:$AS",25,FALSE ) where b1 contains one of those worksheet names. bongiman wrote: How do I use a vlookup equation on sheet 1 which contains a column with all the tab names, eg 60093, 60094,....etc, to pull required data from the respective tabs. The equation i'm currently using is as follows =VLOOKUP($D30,'60093'!$F:$AS,25,FALSE) Any help would be much appreciated. Thanks -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup equation on multiple tabs
Is there a way to use this same function to select a certain cell? I'm
looking through multiple sheets for a sheet that has "test" in cell C3, and on that sheet, I want the function to read cell F7... "Dave Peterson" wrote: Oops. Glad you got it working. bongiman wrote: I was trying to get that indirect formula to work for ages before you posted your reply. Apart from the missing closing bracket before ,25 it's perfect.....you're a genius! =VLOOKUP($D30,indirect("'"&b$1&"'!$F:$AS"),25,FALS E) "Dave Peterson" wrote: Maybe... =VLOOKUP($D30,indirect("'"&b$1&"'!$F:$AS",25,FALSE ) where b1 contains one of those worksheet names. bongiman wrote: How do I use a vlookup equation on sheet 1 which contains a column with all the tab names, eg 60093, 60094,....etc, to pull required data from the respective tabs. The equation i'm currently using is as follows =VLOOKUP($D30,'60093'!$F:$AS,25,FALSE) Any help would be much appreciated. Thanks -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup equation on multiple tabs
Formulas don't select cells.
And I don't understand the rest of the question. You may want to rephrase and try again. Dee Mains wrote: Is there a way to use this same function to select a certain cell? I'm looking through multiple sheets for a sheet that has "test" in cell C3, and on that sheet, I want the function to read cell F7... "Dave Peterson" wrote: Oops. Glad you got it working. bongiman wrote: I was trying to get that indirect formula to work for ages before you posted your reply. Apart from the missing closing bracket before ,25 it's perfect.....you're a genius! =VLOOKUP($D30,indirect("'"&b$1&"'!$F:$AS"),25,FALS E) "Dave Peterson" wrote: Maybe... =VLOOKUP($D30,indirect("'"&b$1&"'!$F:$AS",25,FALSE ) where b1 contains one of those worksheet names. bongiman wrote: How do I use a vlookup equation on sheet 1 which contains a column with all the tab names, eg 60093, 60094,....etc, to pull required data from the respective tabs. The equation i'm currently using is as follows =VLOOKUP($D30,'60093'!$F:$AS,25,FALSE) Any help would be much appreciated. Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup multiple tabs | Excel Discussion (Misc queries) | |||
| Excell 2007 Vlookup linking multiple tabs | Excel Worksheet Functions | |||
| Vlookup and Hlookup equation | Excel Discussion (Misc queries) | |||
| How do I use VLOOKUP to ref multiple workbooks with multiple tabs? | Excel Discussion (Misc queries) | |||
| Vlookup across multiple tabs | Excel Worksheet Functions | |||
Hybrid Mode
