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.
>
>
>