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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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.