Please don't multi-post. Below is the response to your posting in .misc

Assume that sheetname in Catering Destinations-Directions.xls is: Sheet1

First, open the source file, ie open: Catering Destinations-Directions.xls
Check that Sheet1 really exists in there and is named exactly as presumed
(except for case). Watch out for any extraneous white spaces in the sheetname.

Then in your other workbook,
in the sheet containing the vlookup formula
it would be this expression:
=VLOOKUP($J$4,'[Catering
Destinations-Directions.xls]Sheet1'!$A$1:$O$5134,11,FALSE)

Do high-five this response by clicking the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"dwid" wrote:
vlookup formula error. I changed names of sheets in catering
Destinations-Directions worksheet. I'm using this formula to designate a
worsheet with a specific sheet in it. =VLOOKUP($J$4,'[Catering
Destinations-Directions.xls]#REF'!$A$1:$O$5134,11,FALSE)
the error is #REF. I'm thinking i need to put name of sheet there, but
whatever i put in returns error.

thanks for any help