|
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 |
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 |
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 |
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 |
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 |
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 |
Vlookup equation on multiple tabs
Yes, So in "sheet 1" I am creating a summary of the rest of the sheets with
information on them. "Sheet 2" through "Sheet 18" have a cell that has the name of each sheet in it, and then a quantity for that sheet along with other information. On "sheet 1" I want to put in column A the title of each sheet, and then in collumn B I want excel to read what is in Column A, go to the corresponding sheet, and read out just that quantity. "Dave Peterson" wrote: 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 . |
Vlookup equation on multiple tabs
I think...
If you have "Sheet 2" in A1 and want to retrieve the value of Z99 of "Sheet 2", you can use a formula like: =indirect("'" & A1 & "'!z99") or =if(indirect("'" & A1 & "'!z99")="","",indirect("'" & A1 & "'!z99")) Dee Mains wrote: Yes, So in "sheet 1" I am creating a summary of the rest of the sheets with information on them. "Sheet 2" through "Sheet 18" have a cell that has the name of each sheet in it, and then a quantity for that sheet along with other information. On "sheet 1" I want to put in column A the title of each sheet, and then in collumn B I want excel to read what is in Column A, go to the corresponding sheet, and read out just that quantity. "Dave Peterson" wrote: 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 . -- Dave Peterson |
| All times are GMT +1. The time now is 12:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com