ExcelBanter - Vlookup equation for multiple tabs

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Vlookup equation for multiple tabs (https://www.excelbanter.com/excel-discussion-misc-queries/220076-vlookup-equation-multiple-tabs.html)

bongiman

Vlookup equation for 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

Dave Peterson

Vlookup equation for multiple tabs

Check your earlier post.

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

All times are GMT +1. The time now is 10:27 PM.