search all tabs for tab name specified & lookup reference?

[BMW]

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 Phillips]

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

--

HTH

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

 

[Bob Phillips]

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)

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

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

--

HTH

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

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.

 

[BMW]

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]

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