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