search all tabs for tab name specified & lookup reference?

I'm trying to create a formula that will do the following:

search through all worksheets (either in the same wkbook or a different
wkbook)...for the wksheet name that I specify, and lookup a value from a
reference cell or range.

=VLOOKUP("Oxfam",'[Timesheet.xls]23 Oct 2005'!$A$1:$F$5,2,FALSE)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BMW" <BMW@discussions.microsoft.com> wrote in message
news:2F6D76A9-395E-46B5-9F55-3F9E7FCD8182@microsoft.com...
> I'm trying to create a formula that will do the following:
>
> search through all worksheets (either in the same wkbook or a different
> wkbook)...for the wksheet name that I specify, and lookup a value from a
> reference cell or range.

Hey Bob: I Slready Used this type of Formula in my file...It ONLY looks in
ONE Worksheet, NOT Multiple sheets...What I'm looking for is a formula that
will search the array of sheets and return a certain value from the sheet
name I reference. Please let me know if you can help...Thanks! BMW

"Bob Phillips" wrote:

> =VLOOKUP("Oxfam",'[Timesheet.xls]23 Oct 2005'!$A$1:$F$5,2,FALSE)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "BMW" <BMW@discussions.microsoft.com> wrote in message
> news:2F6D76A9-395E-46B5-9F55-3F9E7FCD8182@microsoft.com...
> > I'm trying to create a formula that will do the following:
> >
> > search through all worksheets (either in the same wkbook or a different
> > wkbook)...for the wksheet name that I specify, and lookup a value from a
> > reference cell or range.
>
>
>

That is how I first started to read it, but then you said for the worksheet
name that you specify, so that can only be one! Confused, I am.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BMW" <BMW@discussions.microsoft.com> wrote in message
news:EF8423FC-B20D-45F7-80EB-3370A4708920@microsoft.com...
> Hey Bob: I Slready Used this type of Formula in my file...It ONLY looks in
> ONE Worksheet, NOT Multiple sheets...What I'm looking for is a formula
that
> will search the array of sheets and return a certain value from the sheet
> name I reference. Please let me know if you can help...Thanks! BMW
>
> "Bob Phillips" wrote:
>
> > =VLOOKUP("Oxfam",'[Timesheet.xls]23 Oct 2005'!$A$1:$F$5,2,FALSE)
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "BMW" <BMW@discussions.microsoft.com> wrote in message
> > news:2F6D76A9-395E-46B5-9F55-3F9E7FCD8182@microsoft.com...
> > > I'm trying to create a formula that will do the following:
> > >
> > > search through all worksheets (either in the same wkbook or a
different
> > > wkbook)...for the wksheet name that I specify, and lookup a value from
a
> > > reference cell or range.
> >
> >
> >

Bob: Thanks for your quick reply and soory about the confusion...I will need
to remove the term "wksheet name that I specify" from my inquiry...Hope this
helps...Thanks!

"BMW" wrote:

> I'm trying to create a formula that will do the following:
>
> search through all worksheets (either in the same wkbook or a different
> wkbook)...for the wksheet name that I specify, and lookup a value from a
> reference cell or range.

Hey...anyone out there that knows how to reslove this one...I know this
hasn't stumped you...LOL...Please reply...Thanks...BMW

"BMW" wrote:

> I'm trying to create a formula that will do the following:
>
> search through all worksheets (either in the same wkbook or a different
> wkbook)...for the wksheet name that I specify, and lookup a value from a
> reference cell or range.