have one workbook that is census and marketing data with the zipcode as the
key, it contains the named range zips1in file name zipcodes2006

what i want to do is have a currently open workbook file name midwest
region, use this zipcode workbook, keying off the zipcodes using the vlookup.

how do i write the formula to refer to another workbook, with a named range?
e.g.
vlookup(zips2, {go zipcodes.xls then zips1},field) where zips1 and zips2 are
named ranges.

i think yo can still go the c:\documents and settings\owner\excel\marketing
data\\zipcodes2006!$zips!$--can you just point and click??
Thanks