Trying to fix my vlookup command. The range is a separate worksheet, a
specific sheet within the worksheet. Following is command with REF error,
need to put name of sheet i believe after name of worksheet but everything i
try returns error. thanks for any help
=VLOOKUP($J$4,'[Catering
Destinations-Directions.xls]#REF'!$A$1:$O$5134,11,FALSE)