Vlookup equation for multiple tabs

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
 
D

Dave Peterson

Check your earlier post.
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup equation on multiple tabs 7
vlookup multiple tabs 4
VLOOKUP and IF Statements 2
IF statement with multiple VLOOKUPs 0
If equation with a VLookUp 3
Vlookup help 4
vlookup across multiple tabs 0
how do i link the names of tabs in a workbook to a summary page? 1

Top