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.