Vlookup equation on multiple tabs

  • Thread starter Thread starter bongiman
  • Start date Start date
B

bongiman

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
 
Maybe...

=VLOOKUP($D30,indirect("'"&b$1&"'!$F:$AS",25,FALSE)

where b1 contains one of those worksheet names.
 
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,FALSE)
 
Oops. Glad you got it working.
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,FALSE)
Click to expand...
 
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
 
Formulas don't select cells.

And I don't understand the rest of the question. You may want to rephrase and
try again.

Dee said:
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
Click to expand...
 
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.
 
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 said:
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.
Click to expand...
 
Back
Top