vlookup
 

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

vlookup
 

Check your other post for a response
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---