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