=Vlookup(A1,Indirect("Summary!A1:Z26"),2,False)

You will get an error while the sheet is missing, but as soon as you bring
in another named summary, it should work again.

--
Regards,
Tom Ogilvy

"Sean" wrote in message
...
I coded functionality into a master workbook to browse & attach a
worksheet
from another closed workbook so I could use its data in the master
spreadsheet. I use vlookup in that master workbook to pull the data from
the
spreadsheet I just imported.

How can I set the Table Array reference in vlookup to recognize an
imported
worksheet named 'Summary' instead of getting the error #ref! ? (I built
the
spreadsheet with a summary page attached so that I could be sure my
vlookups
were set right but got the #ref! error when I deleted that spreadsheet and
imported another one?