Thank you, Peo.
I will give this a try. I'll let you know!

"Peo Sjoblom" wrote:

There is no built in lookuop that will work over multiple sheets, I would
recommend using Laurent Longre's excellent Morefunc that can be downloaded
here

http://longre.free.fr/english/


descriptions here

http://www.rhdatasolutions.com/morefunc/

In your case it would be

=VLOOKUP(Lookup_value,THREED( etc


Regards,

Peo Sjoblom

"Ray Stubblefield" wrote:

I want to create a summary sheet that will lookup a particular cells value on
multiple sheets (averaging 58 sheets) in a workbook (e.g. $J$19) based upon a
cell next to it ($I$19) that will match the criteria on the summary sheet
(e.g. w1, w2, w3).
I have tried VLOOKAllSheets but when there are other similar workbooks open,
it doesn't work right.
Anyone? I appreciate your help.